Prev: If Statements HELP !
Next: How do I merge an excel worksheet into tables in word
From: Jamie on 10 Mar 2010 14:53
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?
From: zvkmpw on 10 Mar 2010 18:05
> 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.
From: JHL on 11 Mar 2010 13:56
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?
 | 
Pages: 1
Prev: If Statements HELP !
Next: How do I merge an excel worksheet into tables in word