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
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