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?