#N/A Return in nested IFS formula

[mcgonma]

Column G has Country codes in it (US,CA,LU,BE,NL,IT,ES,GB,DE,CZ,SK,FR,IE,AU,NZ,JP,CN,SG,KR).

In column AT I have an IFS formula to tell me if Column G has any of the country initials for the EMEA region (LU,BE,NL,IT,ES,GB,DE,CZ,SK,FR,IE) so I can identify if a person is part of any of those countries.

=IFS(G20785="lu","YES",G20785="be","YES",G20785="nl","YES",G20785="it","YES",G20785="es","YES",G20785="gb","YES",G20785="de","YES",G20785="CZ","YES",G20785="sk","YES",G20785="fr","YES",G20785="ie","YES")


Two questions:
1) I am getting a #N/A if the cell in G does not meet the condition, how do I modify this so that it returns something else like a blank or "-"?
2) Is there a better formula to accomplish this instead of the IFS?

 

[njimack]

=IF(OR(G20785={"LU","BE","NL","IT","ES","GB","DE","CZ","SK","FR","IE"}),"Yes","")

 

[mcgonma]

Brilliant!!!! Thank you so very much!!!!