Matching records in two lists

[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?

 

[zvkmpw]

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.

Sounds like a job for the COUNTIF() function.

 

[JHL]

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