Multiple logical functions resulting in multiple outcomes

**Ron Coderre** · 12-13-2012, 11:52 AM

For simplicity...try this example:
G1:H8 contains this list

YYYY	Text 1
YYYN	Text 2
YYNN	Text 3
YNNN	Text 4
NNNN	Text 5
NNNY	Text 6
NNYY	Text 7
NYYY	Text 8

Each cell in A1:A4 contains either "Y" or "N"

This regular formula returns the Col_H text that corresponds to the A1:A4 concatenated value
A5: =INDEX(H1:H8,MATCH(A1&A2&A3&A4,G1:G8,0))

Is that something you can work with?

**PaddyG** · 12-13-2012, 12:20 PM

Originally Posted by Ron Coderre

For simplicity...try this example:
G1:H8 contains this list

YYYY	Text 1
YYYN	Text 2
YYNN	Text 3
YNNN	Text 4
NNNN	Text 5
NNNY	Text 6
NNYY	Text 7
NYYY	Text 8

Each cell in A1:A4 contains either "Y" or "N"

This regular formula returns the Col_H text that corresponds to the A1:A4 concatenated value
A5: =INDEX(H1:H8,MATCH(A1&A2&A3&A4,G1:G8,0))

Is that something you can work with?

By George, I think I can! Preliminary results seem favourable.
Many, many thanks.