Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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' |