Threeway lookup

O

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
 
C

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
 
A

Alan Beban

Ola said:
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
Click to expand...
It's the range name of the range that comprises the table of data from
which you're seeking a value.

Alan Beban
 
Top