I suspect you need a customs VBA function:


Function celFormula(C As Range) As String
celFormula = Cell.Formula
End Function




willemeulen wrote in
:


Does anyone know if it is possible to retrieve a fromula instead of a
value from another cell.

Now I have a huge lookup table where I use match/index function to
retrieve formula's result. For each cell I have all possible results
calculated (+/- 360 rows by 40 columns), depending on the code
(columns=formula) it returns the value. But I'm wondering if excel
does have any function/command to retrieve a formula while looking up
and not the result. This would do away with my huge lookup table,
instead I would have only a small lookup table with formula's and only
use a vlookup to retrieve the formula (40 rows by 2 columns). Problems
would be that the formula must overwrite the vlookup funcion or write
the formula in another cell.

Thanks,

W





--