Threeway lookup

[Ola Sigurdh]

I found this on David McRitchie´s site on how to do a three way lookup

=INDEX(data,MATCH(A10&A11,A3:A8&B3:B8,0),MATCH(A12,2:2,0))
Where A10 contains variable plant (Plant A) and A11 contains variable
product (Prod B) and A12 contains the variable month (March)
array-enter

But I cant seem to make it work. I understand the Index and Match functions
but what is data in the beginning after index mean.

TIA

Ola

 

[CLR]

Hi Ola...........

I can't answer your specific question, but if by "Three way lookup" you mean
you want to look up a specific combination of values in three different
cells.........then you can also do this with Concatenation.............such
as =VLOOKUP((A1&A2&A3),YourTable,2,false) ........or you can even look up
portions of the cells with something like
=VLOOKUP((left(A1,3)&A2&right(A3,4)),YourTable,2,false)............and of
course, set up the VLOOKUP table to have the concatenated combinations
you're looking for in the leftmost column of the table...........

Vaya con Dios,
Chuck, CABGx3

 

[Alan Beban]

I found this on David McRitchie´s site on how to do a three way lookup

=INDEX(data,MATCH(A10&A11,A3:A8&B3:B8,0),MATCH(A12,2:2,0))
Where A10 contains variable plant (Plant A) and A11 contains variable
product (Prod B) and A12 contains the variable month (March)
array-enter

But I cant seem to make it work. I understand the Index and Match functions
but what is data in the beginning after index mean.

TIA

Ola

It's the range name of the range that comprises the table of data from
which you're seeking a value.

Alan Beban

 

[Ola Sigurdh]

It's the range name of the range that comprises the table of data from
which you're seeking a value.

Alan Beban

Thank you Alan

Ola