=IF(COUNTIF(A:A,"criteria"),"Yes","No")


"Ranjit kurian" wrote:

Hi
i know to do vlookup, but the problem here is, when i do vlookup function
and if the value is found then the result should be shown as "YES" if not
then "NO"