Lookup Help

[cra88]

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

 

[Jason]

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

 

[Ashish Mathur]

Hi,

You may go through this article

http://office.microsoft.com/en-us/excel/HA012260381033.aspx?pid=CL100570551033

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com