help with contains formula

[rhino80]

HI,

I have the below formula that work's, but I am wanting to add more criteria's to it.

=IFERROR(INDEX(TBLBM[Line of Business],MATCH(A2,TBLBM[Account Number],0)),IF(OR(MAPPED!S2="SBB",MAPPED!S2="SF1",MAPPED!AV2=3),"Commercial Mortgage","Residential Mortgage - Retail"))

What I wish to Add is if the cell MAPPED!L2 contains the work upfront in it, then to populate as Adjustment - Upfront. Then to also look at the same cell of MAPPED!L2 and if it contains trail, then to populate as Adjustment - trail.

any help will be great.

Thanks

[CARACALLA]

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.