Excel Magic Trick 971: Which Answer Was Selected 1, 2, 3, 4? MATCH function to Find 'Y'.

Setup: Four cells contain one "Y" and 3 "N"s. Use MATCH function to find the relative position of the "Y" in a row.

[excelisfun]

This could work:

=INDEX($A$5:$D$5, MATCH("Y", A6:D6, 0))

[krn]

How about returning the A1-A4 versus the position number?