=IF(ISNUMBER(SEARCH("A*P*",K6)),"Pear",IF(ISNUMBER(SEARCH("A*L*",K6)),"Leaf",""))
In column K -- starting with K6 data and down I have the above formula(s) to identify which are "Pear" and which are "Leaf" displaying a result in Column AH.
Now I am stuck because I have to add another identifier to the same formula and display the result "orange" in the same AH Column of cells.
Basically I need something that is not "A*P* nor "A*L*" and identify it as "Orange"
HOpefully that makes some sense., I am new here and trying to take excel to another level.....thank you for all help and direction in advance...
-rt
Bookmarks