execute a different formula basis cell value

[PrashanthKumar123]

hi - I am working on a text string project.

Few sample keywords include -

IMPS OUTWARD

PURCHASE SUBJECT

INTERCITY ECS

In the below table, col A has few sample entries in my input data. Col B recognizes the string based on the above keywords. My next step is to execute a formula based on Col B cell values, i.e., a different formula for "IMPS OUTWARD", another for "PURCHASE SUBJECT and another for "INTERCITY ECS". Presently, I have a nested if to do this, but as my list of keywords increases, I worry if should look at a better way.

IMPS OUTWARD ORG UPI To XXXXXXXX6607@icic0000183.ifsc.npci,REF NO - 024519820714, UPI	IMPS OUTWARD	Formula for IMPS Outward
IMPS OUTWARD ORG UPI To paytmqrXXXXXXXXX1015tmy4w7ksb2r@paytm,REF NO - 024620963921, UPI	IMPS OUTWARD	Formula for IMPS Outward
IMPS OUTWARD ORG UPI To umakumpatla70@okhdfcbank,REF NO - 024817061778, UPI	IMPS OUTWARD	Formula for IMPS Outward
PURCHASE SUBJECT: MCUPOS 02SEP1156 Card no.: XXXXXXXXXX 02SEP20 115640 Innovative Retail Conc\BIGBASK Ref: 024616394551	PURCHASE SUBJECT	Formula for Purchase Subject
IMPS OUTWARD ORG UPI To qXXXX0411@ybl,REF NO - 024820419752, UPI	IMPS OUTWARD	Formula for IMPS Outward
INTERCITY ECS. PAID NACH:Paid to HDFCLTD:HDFC01651000012196:HDFC BANK LTD Refno:262549161 -HDFC BANK	INTERCITY ECS	Formula for Intercity ECS

 

[Fluff]

Glad we could help & thanks for the feedback.