If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|