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!