Searching for multiple strings and return multiple solutions

[Ron]

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]

Maybe...

=IF(ISNUMBER(SEARCH("line",C1)),"Line",
IF(ISNUMBER(SEARCH("point",C1)),"Point",
IF(ISNUMBER(SEARCH("text",C1)),"Text","")))

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'

 

[Ron]

Dave,
Your the man!
Thanks!

Maybe...

=IF(ISNUMBER(SEARCH("line",C1)),"Line",
IF(ISNUMBER(SEARCH("point",C1)),"Point",
IF(ISNUMBER(SEARCH("text",C1)),"Text","")))

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'