look up a value

[sjl]

A B C D E
1 3 6 9 12
2 5 SAM
3 10
4 15
4 20

How do I search for the intersection of "5" and "9" to get "SAM". I cannot
use a vlookup because the column i am searching changes.

 

[Peo Sjoblom]

http://www.contextures.com/xlFunctions03.html#IndexMatch3


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Ashish Mathur]

Hi,

Try the following index and match formula

=index(A1:E5,match(C1,A1:E1,0),match(A2,A1:A5,0))

Regards,

 

[sjl]

Thanks, i've got it working now.
sjl

http://www.contextures.com/xlFunctions03.html#IndexMatch3


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[sjl]

Works great, thank you.
sjl

Hi,

Try the following index and match formula

=index(A1:E5,match(C1,A1:E1,0),match(A2,A1:A5,0))

Regards,