Index and Match with Transposed Data Sources

[HangMan]

I have two separate sheets, both are massive and it is therefore not practical to transpose the data. I've attached a massively cut down version to show what I need to achieve:

Basically I need to use two look up criteria, i.e. a lookup using column A and column B to find the correct entry in G1:K10, which inturn will display the correct value in column C, so for example if I lookup A2 (AR111) in conjunction with B2 (Land) in G1:K10 it should give me the result of 100 in cell C2 and so on.

I know I need to use Index with Match but I can't figure out how to achive this when the two data sources are transposed. Is this possible to do without transposing the second (lookup) data source?

Many thanks

[JieJenn]

In C2, enter =VLOOKUP(A4,$G$2:$K$10,MATCH(B4,$G$1:$K$1,0),0) and fill the formula

[HangMan]

Hi JieJenn,

That worked perfectly...

Many thanks for your help and the quick reply...