Forum Discussion

Rujhan Gupta's avatar
Rujhan Gupta
Copper Contributor
Jul 18, 2017

Excel: Auto-populate outputs based on input change in a table

I have a very complex financial model made up whose output changes based on the 2 inputs. I want to make a table where the column has all possible values of input 1 and row has all possible value of input 2. Each cell in the table should have the output corresponding to the two inputs. How do I go about this?

Can you provide a link or a function that I can use to do this?

Resources