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

Debns

New Member
Joined
Nov 16, 2017
Messages
5
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!!!
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
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.
 
Upvote 0
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!!!
 
Upvote 0

Forum statistics

Threads
1,223,237
Messages
6,170,928
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top