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*

Hi

P.e. you have manufacturer numbers on Sheet1 in range Sheet1!A2:A1000, and on Sheet2 in range Sheet2!C2:C99.

You enter p.e. into cell Sheet1!X2 the formula
=ISERROR(VLOOKUP($A2,Sheet2!$C$2:$C$99,1,0))
and then you copy it to range Sheet1!X2:X1000. Manufacturer numbers in rows where the formula returns FALSE are missing from Sheet2.

In similar way, you enter p.e. into cell Sheet2!X2 the formula
=ISERROR(VLOOKUP($C2,Sheet1!$A$2:$A$1000,1,0))
and then you copy it to range Sheet2!X2:X99. Manufacturer numbers in rows where the formula returns FALSE are missing from Sheet1.

Thank you Arvil. I'll try it...but first I need to know what p.e. stands for Sorry

Hi duskdjl

Probably easier if I attach the file. These are array formulas, CTRL + SHIFT + ENTER
These will list the values that are in one list but not the other, see if this is of any use!

Kevin

Attached Files

003-Lists.xlsx (16.6 KB, 17 views)

Per example