Excel formula Question

[willwill]

Hi all!

I was trying to display some .xls data by provide a cell for filename input.

Ex. input filename in cell A5, formula will use A5 as filename =[A5]sheet1!a2. <-doesnt work....

Any expert know any ways to do this??

 

[DonkeyOte]

On 2002-11-01 02:21, willwill wrote:
Hi all!

I was trying to display some .xls data by provide a cell for filename input.

Ex. input filename in cell A5, formula will use A5 as filename =[A5]sheet1!a2. <-doesnt work....

Any expert know any ways to do this??

Almost there willwill

=INDIRECT("["A5&"]Sheet1!A2")

where A5 = Book1.xls etc

Excel reads as =[Book1.xls]Sheet1!A2

 

[willwill]

hi

But it said error??

 

[DonkeyOte]

OK well you can amend to:

=INDIRECT("'C:MrExcelNov01["&A5&"]Sheet1'!A1")

Does that work....(obviously amending the file path...(you may get an error as a file may be in a different folder so probably best to use full string at all times).

Soz
Luke

 

[willwill]

woohoooo~~~

Thank you so much