function for search

[NickySven]

I have an extensive list of phone numbers in both column A and B. In column c
I have entered aprox. 100 phone numbers. Next to each number in coulumn C,
In column D I would like it to output with a yes or no if that number matches
any of the thousands in column A or B exaclty

 

[Lars-Åke Aspelin]

I have an extensive list of phone numbers in both column A and B. In column c
I have entered aprox. 100 phone numbers. Next to each number in coulumn C,
In column D I would like it to output with a yes or no if that number matches
any of the thousands in column A or B exaclty

Try this formula in cell D1:

=IF(AND(ISERROR(MATCH(C1,A$1:A$10000,0)),ISERROR(MATCH(C1,B$1:B$10000,0))),"no","yes")

Change the 10000 to be at least as high as you have numbers in column
A and B respectively.
Copy this formula down as many rows as you have phone numbers in
column C.

Hope this helps / Lars-Åke

 

[T. Valko]

Try this...

=IF(COUNTIF(A:B,C1),"Yes","No")

Copy down as needed