Repeated text in formula writing

[Joseph M. Yonek]

I am developing very large nested functions. Many parts of the formula are
repetitions throughout the formula. Primarily vlookup functions used to
look up values.

Is there a way to write a shortcut to reduce the length of the formula and
make them easier to understand.

Thanks in advance.

Joe

 

[Bob Phillips]

Joseph,

Put the formula that is repeated in a separate cell, and then use that cell
in the 'real' formula. For instance, in J1
=ThisIsMyRepeatedFormula

In A1,
=IF(A1=17, doSomething,IF(A1=18,doSomethingElse, ... etc.

 

[Dave Peterson]

Use a helper cell that contains the common =vlookup() formula. Then refer to
that cell in your long formula.