Known factors for output:
Desired results for Column A in Column B:
I know the formula =IF(ISNUMBER(SEARCH("Cash",A1)),"DEPOSIT") will work. However, the formula is becoming harder and harder to update with all of the different searches and i would like to build a table to cross reference so it is easier to update when adding or removing items from the formula.
Can you help? I appreciate any assistance or advice!