Sorry, guys, I think this is a trivial question, but I couldn’t find this answer in my researchs.
This question is a follow up of this one (just in case someone needs more details): CALC: How to lookup a formula instead of a value
I have two spreadsheets: one with rules and respective formulas; and the other with my choices of rules (a rule could not be chosen, or even be chosen more than once). The second spreadsheet has each rule attached to its respective formula retrieved by:
So, I have in the second spreadsheet a “text formatted” formula.
Let’s say that I have these:
'= Sheet1.$B1*C1 (result of the formula above)
How do I apply the formula in Sheet2.D1 to Sheet2.E1, for example, to get the resulting