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

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

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

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

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

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

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



"Elana" wrote:

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