IF statement

[Sully]

(if statement is in Column h)
I want it to look at the value in cell A1 and if it equals
one of the values in a list on "sheet2" cells A1 thru
A200" I want the result to say "YES". If the value is not
in the list of values on the sheet2 I want the result to
say "NO"

This is what I have tried to no avail
=IF(A1='sheet2'!A1:A200,"Yes","No")
The result is alway No even though there are values in
Sheet2 that match.
What am I doing wrong??

 

[JE McGimpsey]

Try:

=IF(COUNTIF(Sheet2!A1:A200,A1),"Yes","No")

 

[Guest]

Thanks VERY much!!!

-----Original Message-----
Try:

=IF(COUNTIF(Sheet2!A1:A200,A1),"Yes","No")


.