Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possible to let excel return a formula instead of the cells value. At
this stage I need to write all possible formula's for each cell (vlookup will return the corret one depending on a code inserted by user). I was wondering if it was possible to return a formula instead of a value. This would make my lookup table considirable smaler and avoids repeating all formulas 60 times. And I only have to edit one formula/cell to correct mistakes. Example: Cell B3 on Sheet2 contains the following O&row/P&row * Q&row I want excel to actually return this formala to the cell on sheet1 and not the result. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return formula in cell | Excel Worksheet Functions | |||
Formula to return cell position | Excel Worksheet Functions | |||
function CELL() to return the formula in the referenced cell | Excel Worksheet Functions | |||
formula to return certain cell | Excel Discussion (Misc queries) | |||
Formula to return the name of a cell | Excel Discussion (Misc queries) |