Data table linked to a data-validation drop down

Hi All,

I'm building a model with multiple scenarios that can be picked from a data-validation dropdown.

I want my summary tab to display the results of each scenarios for a couple of cells. Just so the person looking at the model can compare the results of the assumptions, without having to select them one by one.

The data table works well, however, when something other than the first option in the drop-down is selected, the data in the data table gets shifted around. Is there a way to fix this? Are there better options?

Thanks,

Thanks for that, I'll work on getting an example file ready to share.