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.

http://www.contextures.com/xlFunctio...ml#IndexMatch3


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"sjl" wrote in message
...

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.

Hi,

Try the following index and match formula

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

Regards,

"sjl" wrote:


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.

Thanks, i've got it working now.
sjl

"Peo Sjoblom" wrote:

http://www.contextures.com/xlFunctio...ml#IndexMatch3


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"sjl" wrote in message
...

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.

Works great, thank you.
sjl

"Ashish Mathur" wrote:

Hi,

Try the following index and match formula

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

Regards,

"sjl" wrote:


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.