Repeated text in formula writing

  • Thread starter Thread starter Joseph M. Yonek
  • Start date Start date
J

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
 
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.
 
Use a helper cell that contains the common =vlookup() formula. Then refer to
that cell in your long formula.
 
Back
Top