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