INDIRECT

[mcarter973]

I have the following formula:

=INDIRECT(A5&"'[January 2002.xls]'!AM11")

where A5 = Sheet1 (all tabs in .xls file are sheets (Sheet1, Sheet2,...)

it's returning #REF!

what am doing wrong?

thanks.

[Ian Mac]

On 2002-03-28 10:36, mcarter973 wrote:
I have the following formula:

=INDIRECT(A5&"'[January 2002.xls]'!AM11")

where A5 = Sheet1 (all tabs in .xls file are sheets (Sheet1, Sheet2,...)

it's returning #REF!

what am doing wrong?

thanks.

try changing to:

=INDIRECT("'[January 2002.xls]"&A5&"'!AM11")

Note: this function will only work if the other book is open.

otherwise you will get a #REF! error

_________________
Share the wealth!!
Ian Mac

[ This Message was edited by: Ian Mac on 2002-03-28 10:45 ]