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/xlFunctio...ml#IndexMatch3


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"sjl" <[email protected]> wrote in message
news:[email protected]...
>
> 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.

[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" 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.

[sjl]

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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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.
>
>
>

[sjl]

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.