Hi,

I need the help of a guru. I'm an intermediate (NOT ADVANCED) user tasked with an assignment and I'm not sure of the best way to execute the idea. I have two spreadsheets FILLED with data. I have to take Manufacturer numbers from a column in one spreadsheet, and compare them to the the manufacturer numbers in a similar column of another spreadsheet to find matches. There are thousands of numbers! What is the best and quickest way to do this?! I would love to open List B and run a check for all the numbers from List A at the same time. Hope I'm making sense because I need a savior.

Please answer my question (in a user-friendly, step by step fashion if you would) and consider your good deed for the day done!

Thanks,

*Overwhelmed*