Formulas to Pull out text in Description

Closed
Report
Posts
2
Registration date
Thursday December 10, 2015
Status
Member
Last seen
December 11, 2015
-
Hello,

I need a formula that will produce the following results:

Actual:
A1. Cash 10/2/15
A2. CC Application 10/4/15
A3. Check 10/17/15

Known factors for output:
Cash=DEPOSIT
CC Application=CC
Check=DEPOSIT

Desired results for Column A in Column B:
B1. DEPOSIT
B2. CC
B3. DEPOSIT

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?