Help!! Filtering large number of data!

Hello, new member and first time poster here. I apologize if this is the wrong sections or if this has been answered already. I tried searching couldn't find anything that works.I have an excel sheet with customer information, column A has ID #, B-Name, C-last Name, D-DOB, e-Address, f-city, g-zip. I have over 60,000 rows of data, each row being a different customer. I have the ID #'s for 3,000 of these customers on a different sheet, that i need to pull all the info on at once (name,address, dob) to mail out a letter to. How can i filter the 60000 entries to show only the 3000 customers that i need ? I need to collect all the information at once to send to a vendor to print and mail the letters.

Based on the limited information provided, you could possibly use VLOOKUP. Or depending on the structure of your data, LOOKUP or INDEX/MATCH.


Regards, TMS

See this...

http://contextures.com/xlFunctions02.html

If the ID is in the leftmost column, you can use VLOOKUP.

Suggest you post a sample workbook for a more detailed response.


Regards, TMS