Regarding an Excel sensitivity I'm trying to compile, I have a model I built where there is one very important input and two very important outputs. I'd like to show a sensitivity that calculates each of the two important outputs for every given value of the one important input. Ex:

Input (given) | Output 1 | Output
x% | a value 1 | b value 1
y% | a value 2 | b value 2
z% | a value 3 | b value 3

I feel like there is probably a simple set up using the 'what-if' functionality, but it's escaping me for some reason. Any help would be most appreciated.

Thanks,

Charles