Matching records in two lists
 

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?

Matching records in two lists
 

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.

Matching records in two lists
 

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

"Jamie" wrote:

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?