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