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