Scenario and Index Table in Excel

what i want is to see in the table in d16:e17 are the results of (in this case) 2 scenarios.

in scenario A - d16:e16


the IRR should be 3.72% and EIRR 6.89%

in scenario B - - d17:e17

the IRR should be -2.06 and EIRR 3.30%

The benefit of the drop down is simply to allow me to use 1 spreadsheet for each scenario and not have to have a separate one for each scenario .

if i have separate sheets i need to have separate links and that gets very messy. (my actual spreasheet have many links to other sources)

so i want 1 spreadsheet and 1 table of answers.