View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default 'INDIRECT'ly referred cell's own simple formula fails....

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