Check if a value exist in a column

hello,
I do not want to use VLOOKUP. Is there another way to check if my value
exist in a column and if it does then it should just write YES.
Thank you for your help!
DJ Steffo

Try COUNTIF.

=IF(COUNTIF(A:A,"my value")>0,"Yes","No")

HTH,
Paul


"DJ Steffo" <DJSteffo@discussions.microsoft.com> wrote in message
news:5AB04908-7BE5-4AB0-B61A-C62BDA870D2D@microsoft.com...
> hello,
> I do not want to use VLOOKUP. Is there another way to check if my value
> exist in a column and if it does then it should just write YES.
> Thank you for your help!
> DJ Steffo