I have three worksheets at the bottom.
Assumptions- where info is filled out
Results 1- depending on the model, this results tab may be used
Results 2- depending on the model, this results tab may be used
Assumptions tab, I want to reference cells in either the
Results 1 tab or
Results 2 tab, depending on which model is being used. How do I use an IF or VLOOKUP or indirect function to do this?
This is my formula, which works great unless I delete
Results 1 in which case, I want it to look at the same cell in