Question on comparing two tables and retrieving the corresponding value

[syed.yunas]

Hi,

I have two sheets in excel. In sheet 1, I have three columns A, B and C. Column A and B are cartesian coordinates (x,y) e.g. (A1, B1) form one cartesian point. For each point (A,B) there is a value in Column C.

In Sheet 2, I have two columns A and B, they also represent the coordinates (x,y) and Column A and B in sheet 2 are actually subset of Column A and B in sheet 1.

What I want to do is, make a third column in sheet 2 and retrieve a value of C from sheet 1 that corresponds to (A,B). More elaborately, I want to match the (A,B) of sheet 2 to (A,B) of sheet 1 and retrieve the corresponding C value.

What formula should I use. Thanks

[DonkeyOte]

If the A,B combinations are unique...

Sheet2!C2:
=LOOKUP(2;1/(Sheet1!$A$1:$A$100&"@"&Sheet1!$B$1:$B$100=$A2&"@"&$B2);Sheet1!$C$1:$C$100)

modify ranges etc as appropriate.

(above assumes all combinations on Sheet2 are to be located on Sheet1 given they are stated to be a subset thereof)