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

K

Kedar Agarkar

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
 
C

Charles Williams

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
 
K

Kedar Agarkar

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top