In Excel, how do I add "not in list" to an if statement?

[Elana]

I'm trying to figure out how to write the following if(XXX is not in
list,then WW,otherwise YY). How do I write the "not in list" section of this
if statement?

 

[Mike H]

Maybe

=IF(ISNA(VLOOKUP("xxx",A1:A6,1,FALSE)),"WW","YY")

Mike

 

[Elana]

You're awesome. It worked! Thank you!

 

[Mike H]

I think awesome may be a bit OTT but glad I could help and thanks for the
feedback.