Indirect function

[Malcolm1978]

Hi,

I am trying to use the indirect function so that it looks up a cell or cell range in a different workbook, could anyone tell me what the best way of doing this is?

Cheers

Malcolm

 

[Richard Schollar]

Hi Malcolm

Importantly, the target workbook must be open too, otherwise the Indirect function will return an error. What kind of formula were you thinking of?

 

[edvwvw]

The link below gives the syntax for INDIRECT

http://support.microsoft.com/kb/213933

edvwvw

 

[Malcolm1978]

HI,

I currently have the formula:

INDIRECT("'"&$E12&"'!$D$4")

where E12 is the nameof the sheet and D4 the target cell, I was just wondering whether it would be possible to extend this to look up a new book, for example BOOK2. How would I do this?

Cheers

Malcolm

 

[Richard Schollar]

=INDIRECT("'[Book2.xls]Sheet1'!D4")

would be the syntax required to lookup D4 on Sheet1 of Book2.xls (this assumes that Book2 has already been saved down so that it does indeed have an .xls extension).