Hi guys, newbie here.
Looking for formula that, in row "Description" I have comments like this: "OPPOSITE TAB SIDE DISCHARGE REED AND BOOSTER FRACTURED" or "TAB SIDE DISCHARGE RETAINING BOLT/NUT ASSEMBLY LOOSE IN"
This comments are always different, but always contains Opposite tab and/or Tab side
I need a formula that will dump information type: Opposite tab or Tab side, but in case that that description doesn't contain any of them return "Not found"
I have tried this one:
=IF(ISNUMBER(SEARCH("OPPOSITE TAB";O2));"OPP SIDE";"TAB SIDE")
Any idea?
Bookmarks