Hi everyone,

I have a master list of client numbers, and want to filter subsets of clients based on their client number (example below). I already have the desired client numbers listed in columns.

I think my goal would be best described in an example

Column A: List of numbers from 1-1000
Column B: Subset of any numbers between 1-1000 (ie. 34, 203, 498, 939)
Column C: Beside the numbers in column A that match the numbers in column B (but aren't nescessarily in the same row) I need a 1 returned, and beside numbers in column A that do not have a match in column B I would like a 0 returned. To clarify If B1 = 34 I would like to return the value 1 in cell C34 (because A34 = 34).

Basically I want to compare the master list to a "desired client # list", and if the number in the master list matches the number in the desired client # list, return a 1, if the number in the master client list doesn't have a match in the desired client # list return a 0. I need the returned values (0 and 1) put in the same row as the values from the master list.

Overall, I want to use the 1's and 0's to filter the columns containing the matching numbers.

I haven't been able to get IF/OR statements to work. I am comfortable with IF statements on their own, but linking them to OR statements is a challenge to me.

Don't know if this is the best approach, but any suggestions would be marvellous.

Thanks,

John