Search the Lookup table and return result formula

[Brew]

How do I create a formula that checks to see if the value in H4 equal any value in the vlookup table m4:m48, if so, then Y, if not then N. I tried the following formula but it gives me N result for both conditions.

 

[xl_psychic]

dK:

Try this and let me know if it works..

=IF(ISERROR(VLOOKUP(H4,$M$4:$M$8,1,FALSE)),"N","Y")

Hope this helps..

 

[wigi]

Hi

consider

=IF(COUNTIF($M$4:$M$8,H4),"Y","N")

Wigi

 

[Peter_SSs]

.. or this possibly?
=IF(ISNUMBER(MATCH(H4,M4:M48,0)),"Y","N")

 

[Brew]

Thanks everyone for your assistance on this. Wigi, i went with your solution.