function for search
 

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

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

function for search
 

Try this...

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

Copy down as needed

--
Biff
Microsoft Excel MVP


"NickySven" wrote in message
...
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