What-if Analysis doesn't work if Input and result is on different sheet

sajacy / google-sheets-what-if-analysis

Replicates the Excel "What-If Analysis" feature, Data Tables.

MIT License

53 stars 7 forks source link

What-if Analysis doesn't work if Input and result is on different sheet #10

Closed gmadd66 closed 4 years ago

gmadd66 commented 5 years ago

If I have a model which has an input at Sheet1A2 and gets a result Sheet1A5. I cant seem to run the scenario analyses results on a second sheet say Sheet2, which references the Sheet1 inputs and results.

Regards

timhsanchez1 commented 5 years ago

I also have the same issue. I'd like to reference row and column values in a separate sheet, (e.g. "P&L!B16"), but when I do that, it gives me the same output value in every cell of the table.

Thanks, Tim

sajacy commented 4 years ago

Resolved in #6

Thanks for your input! (sorry this has been neglected)