| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for multiple strings and return multiple solutions
I think I'm close in concept but may not be using the correct function.
This formula works except it returns only "Line" or a blank. =IF(OR(ISNUMBER(SEARCH({"Line","Text","Point"},C[1]))),"Line","") Searched data is column C, I need column B to return results as shown below. B C Line 000Default LineLineSymbology Text 001Default TextTextSymbology Point 002Default PointPointSymbology Line 003Plan LineLineSymbology 'empty field' |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for multiple strings and return multiple solutions
Maybe...
=IF(ISNUMBER(SEARCH("line",C1)),"Line", IF(ISNUMBER(SEARCH("point",C1)),"Point", IF(ISNUMBER(SEARCH("text",C1)),"Text",""))) Ron wrote: I think I'm close in concept but may not be using the correct function. This formula works except it returns only "Line" or a blank. =IF(OR(ISNUMBER(SEARCH({"Line","Text","Point"},C[1]))),"Line","") Searched data is column C, I need column B to return results as shown below. B C Line 000Default LineLineSymbology Text 001Default TextTextSymbology Point 002Default PointPointSymbology Line 003Plan LineLineSymbology 'empty field' -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Searching for multiple strings and return multiple solutions
Dave,
Your the man! Thanks! "Dave Peterson" wrote: Maybe... =IF(ISNUMBER(SEARCH("line",C1)),"Line", IF(ISNUMBER(SEARCH("point",C1)),"Point", IF(ISNUMBER(SEARCH("text",C1)),"Text",""))) Ron wrote: I think I'm close in concept but may not be using the correct function. This formula works except it returns only "Line" or a blank. =IF(OR(ISNUMBER(SEARCH({"Line","Text","Point"},C[1]))),"Line","") Searched data is column C, I need column B to return results as shown below. B C Line 000Default LineLineSymbology Text 001Default TextTextSymbology Point 002Default PointPointSymbology Line 003Plan LineLineSymbology 'empty field' -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
