Check if a value exist in a column

[DJ Steffo]

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

 

[PCLIVE]

Try COUNTIF.

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

HTH,
Paul