Thanks for the help thus far. I've been learning about the VLOOKUP function,
but I'm still unable to get it to work for me. Please continue to
advise....here is what I'm attempting to do:
Worksheet 1 - A16:A62 are item numbers (values ranging 3.51:8.12) and
B16:B62 are item descriptions (text entries). On Worksheet 2, I want to be
able to enter a value (3.52:8.12) in column A and have the corresponding item
description autofill into column B. I tried assigning range names, etc, but
something is wrong in my VLOOKUP function.



"Bernard Liengme" wrote:

Sounds like you need VLOOKUP. Learn about this function in Help and then
come back with more questions. If you do, please give a more exact
description of data layout. Something like: in Book1, the item codes are in
A1:A100 and the item names in B1:B100
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jaime.CIS" wrote in message
...
I have created a detailed worksheet that assigns item numbers to entries in
Column A that correspond to item descriptions (text) in Column B. (This
worksheet lists all products for sale by my company.)

I want to create a new worksheet that is a summary page of the above.
Only
actually items purchased (Column D "Qty" is selected), will be carried
over
to this worksheet. I want this worksheet to autfill in some way. Perhaps
when an item number is entered into Column A of the new worksheet, Column
B
will autofill with the corresponding information from the first Worksheet.
There are about 30 possible item numbers/descriptions that could fill any
particular row. How do I formulate an equation for this much information?