Hi

30 or more will be a way too much, but you may have up to 29 various
expressions in a single formula:

=CHOOSE(ExprNum, Expr1, Expr2, ..., Expr29)

, where EprNum may have values 1/2/.../29

Arvi Laanemets


"Mr Machine" <Mr wrote in message
...
Is there a way to return an executable formula from a lookup table?

I'm trying to select a specific formula to use based on a value in the
record (row) where I would perform the calculation. For example, based on
a
code in the data record (row) the desired formula for row 75 might look
like:

Code Formula
110 =(L75+(Q75*KPrice))
112 =(L75+(M75*Dprice)+(Q75*Kprice))

There are over 30 possible codes, each with unique calculations.

A workaround is to calculate the results using each possible formula in a
different column withn the row, use IF statements within each formula to
set
the value to zero unless the code specified in the formula matches the
code
in the data, and summing all the results across all the results columns.
It
works, but brute-forcing it this way is very inefficient and slow.

Any Ideas?