Nested IF formula not working

[Steph_pmg]

I am simplifying a bank reconciliation by identifying each transaction on the bank and GL into categories.
I tried nesting:
=IF(T33="*DES:ACH*","PatientPayment",IF(T33="*CIGNA*","PatientPayment",IF(T33="*DXC*","Dental",IF(T33="*DENTIST*","Dental",IF(T33="*DES:DEPOSIT*","Other AR","")))))

Didn't work.

Then tried nesting with ISTEXT and Search:

=IF(ISTEXT(SEARCH(T143="*DES:ACH*","PatientPayment",IF(T143="*CIGNA*","PatientPayment",IF(T143="*DXC*","Dental",IF(T143="*DENTIST*","Dental",IF(T143="*DES:DEPOSIT*","Other AR")))))),0)

Neither formula is identifying the texts in column T. Formula is returning False or Nothing.

Any suggestions?

 

[Dave Patton]

try

=IF(SEARCH("DES:ACH",T33),"Patient Payment","Next if")

What is in T33?

 

[Steph_pmg]

Tried that and it didnt work. Column T is the text or "description" Im referencing from. Example: column T could contain: Deposit ACH LOC215, so then I want my reference column to find the "ACH" and title it CASH...

 

[mrshl9898]

You can add to this

=IF(ISNUMBER(SEARCH("*DES:ACH*",T33)),"PatientPayment",IF(ISNUMBER(SEARCH("*CIGNA*",T33)),"PatientPayment","OtherAR"))

*Just saw your last reply, not sure what you are after with returning cash from ACH.

 

[Steph_pmg]

Thank you! that worked.

 

[Dave Patton]

Try putting the text you mentioned in T33 "column T could contain: Deposit ACH LOC215, so then I want my reference column to find the "ACH" and title it CASH"

Try the Search formula

=IF(SEARCH("ACH",T33),"Cash","Next if")

And review with Formula Evaluate