Previous Topic Next Topic

Formula to Pull out text in Description

Closed
afox Posts 1 Registration date Thursday December 10, 2015 Status Member Last seen December 11, 2015 - Dec 11, 2015 at 08:42 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 17, 2015 at 11:13 AM
Hello,

I am looking for 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? I appreciate any assistance or advice!

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 17, 2015 at 11:13 AM
Hi Afox,

Try to add VLOOKUP to your formula.

Best regards,
Trowa
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Why is there a red description bubble in my TikTok video?
LGRYTHM -
Nasha -

7 responses
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response