Index Match Multiple Criteria

Hi,

Having a brain freeze.

See attached excel.

Note the yellow highlighted cells. What i'm trying to do is to match three 3 criteria in the index. Match equity cash flow and loan cashflow, match date of drawdown, but also match for the various scenarios i.e. match drawdown based on CELL B16 toggle Equity 1st, Loan 2nd, Equity/loan parri passu, loan 1st, equity second.

Thanks

Mike

Hi Richard,

Thanks for that works perfectly.

Much Appreciated.
Best,
Mike