Model Output into a Table

[JAMeech]

I have created a two input variable/one output variable model in an Excel Spreadsheet.

What I would like to do is use this model to output a table of data using a range of input values for each of the two inputs.

Is there some way I can automate the creation of such a table?

[Vinodsralian]

Upload sample worksheet with your inputs and desired outputs.......

[JAMeech]

See attached Spreadsheet. The inputs are in cellsB26 and B27. The outputs are in cells I26 and I27. The two tables below the outputs labelled Velocity (kph) in columns and Payload in rows have been manually prepared by running the model with different inputs. The top table takes values from cell I26 while the lower table takes data from cell I27.

Any help with how these data tables can be prepared automatically would be gratefully received.

[JAMeech]

Well, i figured it out. You use the What-If button on the Data Tab and create a Data Table. The help file describes perfectly how to do it. Many thanks for anyone who took a look at this.