Try COUNTIF.

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

HTH,
Paul


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