==Formula

[ebetke]

I am trying to build a formula by adding "=" and the text of an Index,Match,Match formula. The latter is stored on a separate sheet and I am building the formula on another. I have tried a number of ways with no luck. The cell ends up showing =(Index, Match, Match) rather than running the formula.

Thanks for your help.

Eric

 

[Scott Huish]

Either your cells are formatted as text or you are showing formulas instead of the result which can be toggled with CTRL-`