function for search
On Tue, 5 Aug 2008 13:04:04 -0700, NickySven
wrote:
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(M ATCH(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
|