Changing multiple parameters in a sensitivity analysis

Hi, I’m doing a sensitivity analysis and am using the ‘What-if’ function to show the cost-effectiveness ratio if a parameter value is changed to ‘Low’ or ‘High’. These figures are then used as input for a tornado diagram, so the diagram automatically updates if any of the values in the model change.

However, I want to do the same for scenarios that involve the change of multiple parameters, e.g. ‘If costs are Low, effectiveness is High and prevalence is High, what is the cost-effectiveness ratio?’ I can’t see a way of doing this using ‘What-if’. Is there another way?

Thanks.

Bump.

I have made a highly simplified model showing roughly what I need to do.

https://www.dropbox.com/s/pei8ob1ct5...del2.xlsx?dl=0

Obviously the Scenario Manager can deal with multiple parameters, but you have to input them manually. I want the results to automatically update when the source data changes.

If it isn't possible, please just tell me so I don't waste more time trying to figure it out.

Thanks