lookup a value from another worksheet

Hi All,

I am stucked on the formular: I have data sitting in Sheet1. And in Sheet2 range C2:K4, I am trying to look up the value from Sheet1, eg, the value in C2 should be 200, and D2 should be 201..... Can anyone help me with writing a formular?

A sample file is attached.

Any help would be greatly appreciated!

Cell C2: =INDEX(Sheet1!$D$2:$D$28,MATCH(Sheet2!$A2&Sheet2!C$1,Sheet1!$A$2:$A$28&Sheet1!$C$2:$C$28,0))

committed with Ctrl-Shift-Enter rather than just Enter

The formula will be displayed in the formula bar as follows:

{=INDEX(Sheet1!$D$2:$D$28,MATCH(Sheet2!$A2&Sheet2!C$1,Sheet1!$A$2:$A$28&Sheet1!$C$2:$C$28,0))}

copy across and down ... or down and across, whichever.


Regards, TMS