I want to lookup a formula in one sheet that I have stored as text and use it
on another sheet. I know how to do the lookup and am able to bring the
correct formula based on other items in my =vlookup statement. But I can't
get the formula to work in my table.

Ex: the result of my vlookup yields [a]*[b] instead of just multiplying [a]
times [b] and giving the result. How can I make a looked up formula work in
its new location? (I'm using tables, hence the [bracketed] references.)