'INDIRECT'ly referred cell's own simple formula fails....
 

Hi,

ENV: Excel 2003 on Windows XP

I have a cell B$3 on current sheet being refered via 'INDIRECT' call
as:

=VLOOKUP($A4,INDIRECT("'[NEW FNO EOD Data.xls]"&B$3&"'!$B$2:$Z$500"),
8, FALSE) in different places of my current sheet.

For the contents of this cell B$3 ifself, however, when I try to place
a formula to pick its value from other sheet [something like =VCON!A10
VCON being other sheet] looks like formula fails and appears as
"string literal placed in cell". Both cell i.e. B$3 here and VCON's
A10 have same 'format' of 'Text'.

Is this due to any reason that its being referred in INDIRECT call? I
feel there could be some other reason. Other cells [which are not

referred by 'INDIRECT' way work fine].

Clues shall be helpful,

Thanks for your time

- Kedar Agarkar

'INDIRECT'ly referred cell's own simple formula fails....
 

There is no intrinsic reason why you cannot use INDIRECT in this way.

I suggest you use the Evaluate Formula button on the auditing toolbar to
work out exactly what text your formula is passing to INDIRECT
or highlight the interesting bit in the formula-bar and press F9 (Clear to
reset the formula)

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

"Kedar Agarkar" wrote in message
...
Hi,

ENV: Excel 2003 on Windows XP

I have a cell B$3 on current sheet being refered via 'INDIRECT' call
as:

=VLOOKUP($A4,INDIRECT("'[NEW FNO EOD Data.xls]"&B$3&"'!$B$2:$Z$500"),
8, FALSE) in different places of my current sheet.

For the contents of this cell B$3 ifself, however, when I try to place
a formula to pick its value from other sheet [something like =VCON!A10
VCON being other sheet] looks like formula fails and appears as
"string literal placed in cell". Both cell i.e. B$3 here and VCON's
A10 have same 'format' of 'Text'.

Is this due to any reason that its being referred in INDIRECT call? I
feel there could be some other reason. Other cells [which are not

referred by 'INDIRECT' way work fine].

Clues shall be helpful,

Thanks for your time

- Kedar Agarkar

'INDIRECT'ly referred cell's own simple formula fails....
 

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

'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