Lookup? Ranges?

[Guest]

First of all, I have to tell everyone who responds to post how WONDERFUL this
is. I've gotten a LOT of information from you smarties.

I have a workbook with several tabs. One tab has a series of tables for
ordering merchandise by size (lengths across the top, in columns, widths
within the rows). The grid within the column/row headers allows me to enter
quantities by size (length and width). Each of the tables has it's own ID
(not using the NAME function, just from typing in an ID).

What I want to do on the second worksheet is be able to enter that ID and
have the ordered units automatically populated.

I'm assuming it's a VLOOKUP or HLOOKUP but not positive. If this is too
vague, I apologize.

 

[Don Guillett]

You too can become a smartie if you just look in the help index for LOOKUP
and study what it says.

 

[Guest]

Great. Thanks for the help