I have a few (tens of...) formulas stored as regular text in a table. Depending on some initial conditions, I'll have to look one of them up and use it as a regular formula in another cell. The Lookup part is easy to do, but I can't find a way to get Excel to use the looked up text and use it as an actual formula.
As an example, let's say I have 2+A1 stored as text in cell A2. Now I want cell A3 to pick the contents of cell A2, which would be the text, and evaluate it as a formula (essentially the same as inputting =2+A1 in cell A3). Nope, concatenating a text string with the = sign before won't cut it... been there, done that.
Seems easy, doesn't it?...
