Looking up data in a table

[Guest]

I have two different sheets in a workbook. On one shee is a table with the
1st column being a list of circumference values, top row is a list of
heights. The table is filled with various numbers. On the other sheet is a
place to put in a circumference value, a place for height. I need a formula
that will give you the intersection of the row that equals the circumferance
and the column that equals the height from the previous two cells. Any ideas

 

[Biff]

See this screencap:

http://img100.imageshack.us/img100/4141/lookuper2.jpg

Biff

 

[Guest]

Thanks Biff, works like a charm. I never would have thought to nest the
match function.

James

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Thanks Biff, works like a charm. I never would have thought to nest the
match function.

James