ExcelBanter - Look up, not down

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Look up, not down (https://www.excelbanter.com/excel-worksheet-functions/200413-look-up-not-down.html)

mckzach

Look up, not down

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.

Teethless mama

Look up, not down

=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.

All times are GMT +1. The time now is 08:22 AM.