This should be pretty easy for anyone who knows what they're doing, for me its a bit hard. I've attached the small file to make it easier to conceptualize.

I have a list of numbers in A1:A28.

I want to see if the number in D1 is in that list. So in D2 I wrote this formula:
=IF(A1:A28=D1,"YES","NO")

I'm always getting a no tho. Why would that be?


Fil.xlsx