Forum Discussion
Referencing a function instead of the value of the function
Thank you for your response mathetes.
To get more specific, I am trying to use a switch case in sheet 2 to use different formulas on the data in sheet 2. Sheet 1 serves as a reference sheet so I can update or add new formulas in the future and have them update across all other sheets. Currently sheet2!C1 outputs whatever is in the placeholder area in sheet 1 instead of sheet 2.
I hope this helps clearing things up. Best regards!
It's a step in the right direction of clearing things up. I've never used SWITCH before myself, but from what I read about it here, it looks to me as if it only returns values, not formulas. Have you experience with using SWITCH before, in a way that returns formulas?
That said, I wonder if a combination of IFS or CHOOSE and INDIRECT might give you the result you're seeking. With INDIRECT in particular, it is possible to "create" a new formula from parts. It's also a resource-hog of a function, though, so if you were to be employing it widely, your workbook could be very slow.
You've really only shown us, in your images, the tip of the iceberg. Is it possible for you to post a copy of the actual workbook (or sample workbook) with more of the complete iceberg--i.e., examples of those other places in Sheet2 where the formulas exist that you want to have control over. That way, I (or one or more of the others here in the forum who seek to help by answering questions) can more quickly (a) understand the big picture, and (b) test out alternate formulations. Post the actual (sample) workbook on OneDrive or GoogleDrive with a link pasted here that grants access to it.
It also would help if you would be willing to describe the bigger purpose of the workbook, what it is about the situation that you want or need to be able to change formulas within Sheet2. That almost seems like a recipe for disaster; it certainly would be if we were dealing with financial data, for example.