Evaluate a string as an formula in Excel without VBA

Asked Jun 18 '20 at 13:17

Active Jun 18 '20 at 13:17

Viewed 23 times

I am trying to evaluate a formula from a string (Excel). The string is been take it via VLOOKUP() function. I have an table with formulas "Formulas". Via an drop down cell I like to select what Formula I like to apply. This is one of the strings: "pi()*(B5+2*C5/1000)" I have trying the following extra function to complete this task without success:

=INDIRECT(VLOOKUP(A38;formulas;2;))
=INDIRECT("="&"pi()*(B5+2*C5/1000)")
=TEXT(INDIRECT("="&"pi()*(B5+2*C5/1000)");)
=INDIRECT(TEXT(INDIRECT("="&"pi()*(B5+2*C5/1000)");))

So in cell A38 I have an drop down menu: -Function1, Functin2, Function3 etc....

I am not interested in an VBA solution. Maybe exist something without VBA.

Thank you!

asked Jun 18 '20 at 13:17

white_flag

Why no VBA? That *is* the way to do this, and it's very easy. – BigBen Jun 18 '20 at 13:26
From the top op my head, I don't think `INDIRECT` would evaluate through VBA. – JvdV Jun 18 '20 at 13:31
I know it is easy with VBA but I have to do it without VBA (if it is possible). – white_flag Jun 18 '20 at 13:33
See second answer for non vba method. – Scott Craner Jun 18 '20 at 14:02
Be aware that the solution provided won't always recalculate. You can also refer to https://superuser.com/questions/253353/excel-function-that-evaluates-a-string-as-if-it-were-a-formula/1385388#1385388 – jlear Jun 18 '20 at 14:57

Evaluate a string as an formula in Excel without VBA

0 Answers0