function for search

N

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
 
L

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
Click to expand...


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
 
Top