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
|