Help with linking IF/OR statements

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

Hi ConneXionlost, thanks for your input. The COUNTIF function appears to be a way of counting the number of cells that meet a given criteria. I can't quite see how this makes it possible to give my desired results. I don't think I was clear enough describing my problem. Let me pose the problem I am having again.

Master list of customer #'s in column B
Desired list of customer #'s in column C

I need a formula that will return the values given in column A. There needs to be a 1 beside the value in column B that matches a value in column C.

A B C
1 1 1
0 2 4
0 3 7
1 4
0 5
0 6
1 7
0 8
0 9
0 10


Thank you in advance for any help you can provide.

Turns out I just needed to use the advanced filter function.

Anyone with a similar problem check out this YouTube video for a great tutorial on advanced filter.

http://www.youtube.com/watch?v=SU1qGbN6Rs8