Thread: In Excel, how do I add "not in list" to an if statement?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elana Elana is offline
external usenet poster
  
Posts: 2
Default In Excel, how do I add "not in list" to an if statement?
You're awesome. It worked! Thank you!
--
Elana


"Mike H" wrote:

Maybe

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

Mike

"Elana" wrote:

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?
--
Elana
Reply With QuoteReply With Quote