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

Copper Contributor

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?

1 Reply

Hi

 

You may want to have a look at data tables.