One way...

=IF(COUNT(MATCH(X1,Y:Y,0)),"Yes","No")

Copy down as needed

--
Biff
Microsoft Excel MVP


<Kevin Rudd wrote in message
om.au...
Hi

I am trying to check a cell in excel against a column and see if it is
present, if it is then I want a yes or no answer.

All the values are in txt and they are not words, they are codes.

I want to see if a code from cell x appears in column y - then have an
answer yes or no.

I need to then copy this formula through 7000 rows checking the next cell
(below the one above) with the SAME column fields

Thanks

EggHeadCafe - Software Developer Portal of Choice
Table and Stored Procedure Profile Providers for ASP.NET
http://www.eggheadcafe.com/tutorials...-procedur.aspx