I have 2 sheets, the first is a list of 400 model numbers for a specific
customer. The second is a list of all 8000 model numbers in inventory with
location id's. I want to search the list of all model numbers and only
extract the models on the first sheet. The end result needs to be a list of
the models in sheet1 with the location id's from sheet 2. The second issue I
have is sheet 2 will have the same items multiple times because they have
multiple locations. I hope this is making sense to someone.

Thanks

OK, so you want to lookup the location ID from sheet2 for each of the
model numbers on sheet1. Assuming sheet 2's 8000 rows data is in
A1:B8000, and the model number you want to lookup is in cell D2 use the
following formula, and copy for each model number:

=VLOOKUP(D2,Sheet2!$A$1:$B$8000,2,false)

As for your problem that each model number has multiple location IDs
then you would need to decide which location ID you want to lookup; the
lowest numbered? the first in the list?

Jay
--


cra88 wrote:
I have 2 sheets, the first is a list of 400 model numbers for a specific
customer. The second is a list of all 8000 model numbers in inventory with
location id's. I want to search the list of all model numbers and only
extract the models on the first sheet. The end result needs to be a list of
the models in sheet1 with the location id's from sheet 2. The second issue I
have is sheet 2 will have the same items multiple times because they have
multiple locations. I hope this is making sense to someone.

Thanks

Hi,

You may go through this article

http://office.microsoft.com/en-us/ex...CL100570551033

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"cra88" wrote in message
...
I have 2 sheets, the first is a list of 400 model numbers for a specific
customer. The second is a list of all 8000 model numbers in inventory with
location id's. I want to search the list of all model numbers and only
extract the models on the first sheet. The end result needs to be a list
of
the models in sheet1 with the location id's from sheet 2. The second issue
I
have is sheet 2 will have the same items multiple times because they have
multiple locations. I hope this is making sense to someone.

Thanks