Try this...

Sheet1

A B C D E F 1 Header1 Header2 Header3 _ Lookup Location 2 22 10 65 _ 94 Header2 3 44 15 59 _ _ _ 4 48 94 31 _ _ _ 5 33 29 86 _ _ _

This array formula** entered in F2:

=INDEX(A1:C1,MAX(IF(A2:C5=E2,COLUMN(A2:C5)-COLUMN(A1)+1)))

** array formulas need to be entered using the key

combination of CTRL,SHIFT,ENTER (not just ENTER).

Hold down both the CTRL key and the SHIFT key

then hit ENTER.

## Like this thread? Share it with others