modify to suit
=IF(ISNA(MATCH(B1,Sheet18!E:E,0)),"NO","Yes")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Connie Martin" wrote in message
...
I am confused. In Cell A3, I would like a formula that would look at the
number A4 and then go to the next worksheet called 'Nirav' and see if the
number appears in A1:A300, and return "Yes" or "No" in A2 of the first
worksheet. Simple? Wish it were for me. Help, please! Connie