LOOKUP Help

[tuffyskittles]

I am trying to lookup data in another sheet in my workbook. I have
researched, but am not sure if it is possible or if I just need to use a
different function.

I have a bodyfat content table I need to lookup data in. I have the
circumference value in column A and the heights in row 2 and a percentage
corresponding to the individual's circumference value and height. How can I
make this possible if the circumference value and height are found in two
different cells on sheet 1 and the table is on sheet 2?

 

[Max]

One way

In Sheet2,
Assume circumf values in A3 down, heights in B2 across

In Sheet1,
Assume inputs for circumf & height in A1:B1
place in C1:
=OFFSET(Sheet2!A2,MATCH(A1,Sheet2!A:A,0)-2,MATCH(B1,Sheet2!2:2,0)-1)