How can I find multiple items at once in a large list?

[Debns]

I received a spreadsheet with a list of customers (around 200) that I need to find in another larger spreadsheet (column with around 2K customers) in order to obtain their ID code. What is the easiest way to do so? The column with the larger number of customers has a filter, which I could use to find one or two customers, but with such a large list that will take me forever. I could use IF functions but I need to know exactly which customers from my small list were found in my large list.

Hope its not too confusing!

Thanks in advance!!!

 

[mrshl9898]

Are their names identical in both sheets? =VLOOKUP()

 

[Debns]

Are their names identical in both sheets? =VLOOKUP()

Yes!!

 

[mrshl9898]

It's hard to give you a solution without page names, column and row numbers etc.

Basically you want to do something like =VLOOKUP(A2,Sheet1!A:B,2,0)

A2 is the cell with what you are looking for in it

,Sheet1!A:B means you are looking for it in column A and wanting to return the result in column B

,2 is the count of rows between A:B. A is the first row, B the second

,0 is looking for an exact match.



Maybe look up a tutorial if unclear, it is very useful.

 

[Debns]

It's hard to give you a solution without page names, column and row numbers etc.

Basically you want to do something like =VLOOKUP(A2,Sheet1!A:B,2,0)

A2 is the cell with what you are looking for in it

,Sheet1!A:B means you are looking for it in column A and wanting to return the result in column B

,2 is the count of rows between A:B. A is the first row, B the second

,0 is looking for an exact match.



Maybe look up a tutorial if unclear, it is very useful.

Thank you SO much!! Helped a lot!!!