IF AND formula in google sheets

Hi there, I'm struggling to find the right formula to do this.
I basically want column E to = column A, except if column A is "Outbound". If it is "Outbound", then column E should be "Outbound (SDR)" if there is a name in column B, "Outbound (Self-sourced)" if column C = Column D, and "Outbound (other) if neither of these two criteria is met.

Screenshot 2021-05-14 at 16.53.42.png

Can anyone help? Thanks so much

How about

Formula:

Please Login or Register  to view this content.

This worked an absolute treat! thank you so much!!!

You're welcome & thanks for the feedback.