Lookup on 2 Values

[Guest]

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]

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