=if(match... formula showing as error.

[Salimander]

Hi everyone, I need some assistance with a formula. I'm trying to look up if a specific value exists in a specific column, but I'm having difficulty with the formula. I used a different formula to get my answer but I just want to understand why my formula wasn't originally working. It says the lookup array is in red.

=if(match(A1,$C$1:$C$100,0)"YES")

here is my formula. I would appreciate any help if I made any mistakes would you be able to tell me what I did wrong as I'm trying to learn how to do things without having to look it up. Thank you in advance!

 

[Salimander]

Here is the formula on excel

 

[Joe4]

Welcome to the Board!

You are missing the comma just before "YES". It should be:

=if(match(A1,$C$1:$C$100,0),"YES")

 

[Salimander]

I hate myself. Thank you so much I've been spending 2 hours trying to figure out what was wrong

 

[Joe4]

You are welcome.
Glad I was able to help.

 

[mehidy1437]

To avoid #NA, for not matched value.

=IFERROR(IF(MATCH(A1,$C$1:$C$100,0),"YES"),"")