Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Whats the formula in the cell referred to by INDIRECT?
Charles __________________________________________________ Outlines for my Sessions at the Australia Excel Users Group http://www.decisionmodels.com/OZEUC.htm "Kedar Agarkar" wrote in message ... Hi Charles, My VLOOKUP with INDIRECT inside it is working just fine. However, the cell which is being referred in INDIRECT, that cell has some formula to pick its own value. This formula does not work and shows formula string as cell value, hence Evaluate Formala also doe not work. There is some unknown reason why the formula is taken as the cell string value. For other cells elsewhere, formula works [so no error in typing]. Any clues shall help. Thanks - KA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
a range area referred anywhere and repeatively on a new worksheetpage | Excel Discussion (Misc queries) | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Conditional format but referred from other cell | Excel Discussion (Misc queries) | |||
How do I use a referenced cell's formula instead of formula output? | Excel Worksheet Functions | |||
Excel200: Strange behaviour for Name when referred from VBA | Excel Programming |