Hoping someone can help! I'm trying to create a Trade Sheet as my output (the tab is Trade Sheet) that will pick up "Wire To" and "Wire From" wire instructions from the Wire Instructions tab. On the Trade Sheet, the "Wire To" instructions needed will vary depending if it is a Purchase or Rememption, and the "Wire From" instructions will also vary depending if it is a Purchase or Rememption (I already have formulas in A17-A29 for this). I think I need to use nested IF statements combined with Index/Match to pick up the 2 possible scenarios (Purchase or Redemption), but I'm not sure how to do this. I attached my workbook with what the output should be, any help is much appreciated!

Book9.xlsx