Extracting type based on the text!

[Saeidian]

Hello,

I am trying to populate the type of transaction in column C based on the text in Column D and the value in column I. I have attached a sample that works halfway and for some reason it does not work fully. It should insert word Transfer in C2, C4, C11 and C13 but instead inserted word Deposit and Check depend on the value in column I.

Would you please help me?

I really appreciate your help in advance.

Thanks

[alansidman]

No attachments.

[Saeidian]

Sorry about that I just attached it. Thank you so much!