Matching records in two lists

  • Thread starter Thread starter Jamie
  • Start date Start date
J

Jamie

I have a list of part numbers in one range (list) on a worksheet with the
description in another columns. In a seprate range (list) on the same
worksheet, I want to see if there are any matches in the part number column.
How is this done?
 
I have a list of part numbers in one range (list) on a worksheet with the
description in another columns. In a seprate range (list) on the same
worksheet, I want to see if there are any matches in the part number column.
Click to expand...

Sounds like a job for the COUNTIF() function.
 
I had a similar question and this is the answer I received from "Max"

Assume List1 in col A, List2 in col B, type this formula in C2
=If(A2="","",--ISNUMBER(MATCH(A2,B:B,0)))

copy to last row of data in col A
1 - for items in List1 found in List2
0 - for items in List1 not found in List2
blank ("") - if List1 contains any blank cells in between
 
Back
Top