Retrieve formula instead of value

[willemeulen]

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

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

Thanks,

 

[Liliana]

I suspect you need a customs VBA function:


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

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

--