Hello.

Thanks for the info. May be I'm just not doing it correctly, but I can't
seem to get it to work the way that I want. Is there a way I can set the
Lookup_Value as a range? For example, A4:A789 is the list of the items that
I've ordered and B4:Z19876 contains the product info and UPC numbers from the
vendor that I need to extract. The difficulty in this problem is that for
one product number (or item number) there could be 4 UPC codes associated
with it. Will vlookup be able to extract all the UPC codes? Thanks!

"ryguy7272" wrote:

Vlookup will do what you want (search through the help menu for related
information). Also, try using a Pivot Table (search help menu or Google).

Regards,
Ryan--

--
RyGuy


"alimeishi" wrote:

Hello. I'm trying to find a fast and easy way to have excel look up item
numbers listed on my orders (excel 2002) worksheet from the vendor's product
list and then copy the data found from the vendor's product list to a new
list so that I can import that data into my system. I have over 1000 item
numbers so I really would like a fast and quick way to get this task
accomplished. Does anyone have any idea how I can go about doing that? I'm
a bit of a novice when it comes to excel functions so any help would be
greatly appreciated. Thanks!