Lookup on 2 Values
 

I have a data table eg.
CC A CC B CC C
Item 1 50 150 200
Item 2 75 80 90
Item 3 52 54 56

The number of rows and columns vary from day to day

I want to do a lookup to this table in another worksheet that has a fixed
structure that looks at the intersection of a row heading and column heading
and returns the value

eg lookup (CC B & Item 3) will return 54

Any ideas?

Lookup on 2 Values
 

suppose data resides in a range of G4:I9 with G5:G9 verticle headers and
H4:I4 horizontal headers.
INDEX(G4:I9,MATCH("item 1",G5:G9,0),MATCH("CC B",H4:I4,0))
you can also use cell reference instead of typing item 1 and CC B

Bobak Wrote:
I have a data table eg.
CC A CC B CC C
Item 1 50 150 200
Item 2 75 80 90
Item 3 52 54 56

The number of rows and columns vary from day to day

I want to do a lookup to this table in another worksheet that has a
fixed
structure that looks at the intersection of a row heading and column
heading
and returns the value

eg lookup (CC B & Item 3) will return 54

Any ideas?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=539811