Looking up data in a table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James Fullmer - 03 Oct 2006 06:35 GMT

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

Reply to this Message

Biff - 03 Oct 2006 06:55 GMT

See this screencap:

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

Biff

>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
[quoted text clipped - 6 lines]
> and the column that equals the height from the previous two cells. Any
> ideas

Reply to this Message

James Fullmer - 03 Oct 2006 09:10 GMT

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

James

> See this screencap:
>
[quoted text clipped - 12 lines]
> > and the column that equals the height from the previous two cells. Any
> > ideas

Reply to this Message

Biff - 03 Oct 2006 19:19 GMT

You're welcome. Thanks for the feedback!

Biff

> Thanks Biff, works like a charm. I never would have thought to nest the
> match function.
[quoted text clipped - 19 lines]
>> > and the column that equals the height from the previous two cells. Any
>> > ideas

Reply to this Message

Rate this thread: