Greetings all,

I want to find a specific value (1) across Row 3, then look UP to Row 1 and
return the corresponding name (e.g. Jim), as below. What formula do I enter
in cell A3??

A B C D E F
1 Tom Bob Jim Max
2
3 ? 2 3 1 2
4

This seems so simple, but I can't figure it out!
Any help at all would be appreciated. Thanks in advance.

=INDEX(B1:F1,MATCH(1,B3:F3,))


"mckzach" wrote:

Greetings all,

I want to find a specific value (1) across Row 3, then look UP to Row 1 and
return the corresponding name (e.g. Jim), as below. What formula do I enter
in cell A3??

A B C D E F
1 Tom Bob Jim Max
2
3 ? 2 3 1 2
4

This seems so simple, but I can't figure it out!
Any help at all would be appreciated. Thanks in advance.