| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining "IF"statement with "Vlookup" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| embedding "ISERROR" function into an "IF" statement | Excel Worksheet Functions | |||
| cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
| "IF" statement & "strikethrough" formatting | Excel Worksheet Functions | |||
Linear Mode
