=IF(T2=0,IF(ISNUMBER(SEARCH("Redemption",E2)),"Redemption",IF(ISNUMBER(SEARCH("Subscription",E2)),"Subscription",)))

HOWEVER, if T2 does not equal 0, it will equal "Exchange" but i need it to also look at cell P2, and if p2 contains the word "Index" I need the formula to return "Exchange - Index"

Can someone help? do i need to do this in pieces, or is it possible to just have one formula?