Return YES or NOT if text from a list is in this cell

Question

Pretty straightforward but couldnt do it.

I have a list of words on A:A.

I am trying to make a function that will tell you whether or not the word you write in a specific cell is on that list.

So you have the cell B5, and you type "PURPLE". If the word "PURPLE" is on the list (A:A) it will return "Yes" on B6, otherwise it will return "No".

Thank you for your help!

Answer 1

try:

=IF(IFERROR(MATCH(B5; A:A; 0); FALSE)=TRUE; "yes"; "no")