I have a cell I2 which contains long string. I want to find out the following:
If string in I2 contains "month", then return "Monthly",
If string in I2 contains "year", then return "Yearly",
Else, return "other".
I am using the following formula, but I'm just getting #VALUE.
I would appreciate any help or if you can please point out what I may be doing wrong. Thanks a bunch!
Search for multiple substrings and return different values