Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
search for multiple strings
Here is my current formula =IF(ISERROR(SEARCH("move",D4)),0,E4). Now I want
to also search for "carryforward" in cell D4. How can I do that? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
search for multiple strings
Add another =search() to your formula.
But the next question is--what do you want to check for: either/or/or both Either/or, but not both (exactly one) or none =if(and(iserror(search("carryforward",d4)),ISERROR (SEARCH("move",D4))), "neither","at least one") You may want to use =isnumber() instead of =iserror(). That'll be true if the string is in the cell. And you may want to use =Or() instead of =And() in the formula. Lea from CA wrote: Here is my current formula =IF(ISERROR(SEARCH("move",D4)),0,E4). Now I want to also search for "carryforward" in cell D4. How can I do that? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
search for multiple strings
=IF(AND(ISERROR(SEARCH("move",D4)),ISERROR(SEARCH( "carryforward",D4))),0,E4)
-- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Lea from CA" wrote: Here is my current formula =IF(ISERROR(SEARCH("move",D4)),0,E4). Now I want to also search for "carryforward" in cell D4. How can I do that? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
search for multiple strings
In article ,
Lea from CA wrote: Here is my current formula =IF(ISERROR(SEARCH("move",D4)),0,E4). Now I want to also search for "carryforward" in cell D4. How can I do that? Here's another way... =IF(OR(ISNUMBER(SEARCH({"move","carryforward"},D4) )),E4,0) -- Domenic Microsoft Excel MVP www.xl-central.com Your Quick Reference to Excel Solutions |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
search for multiple strings
It works! Thank you so much!
"Gary Brown" wrote: =IF(AND(ISERROR(SEARCH("move",D4)),ISERROR(SEARCH( "carryforward",D4))),0,E4) -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Lea from CA" wrote: Here is my current formula =IF(ISERROR(SEARCH("move",D4)),0,E4). Now I want to also search for "carryforward" in cell D4. How can I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search group of cells for several sets of character strings | Excel Discussion (Misc queries) | |||
How do I filter or search mulitple for text strings? | Excel Discussion (Misc queries) | |||
Search for multiple strings in a list (w/in 1 cell) w/ Advanced fi | Excel Discussion (Misc queries) | |||
Search for strings | New Users to Excel | |||
Fast way to search many cells by column for text strings | Excel Discussion (Misc queries) |