Vlookup

[Leo]

hi I need some help.
I'm doing a vlookup grabbing the reference from one cell.
I'm using:

=VLOOKUP(BL$9,INDIRECT("'[Final Detailed
Budget.xls]"&$Z$4&"'!$A$21:$q$33"),$B$7,0)

This works ok when my file (Final Detailed Budget.xls) is
open. But did not work when I close it.

I'm trying writing the entire path:

=VLOOKUP(BL$9,INDIRECT("'H:\Financial
Analysis\Leo\Budget\[Final Detailed Budget.xls]"&$Z$4&"'!
$A$4:$q$16"),$B$7,0)

But this doesn't work either. Can anybody help me...

Thanks

 

[Frank Kabel]

Hi
INDIRECT does not work on closed workbooks!
There're some alternatives (see link below) But in your case also the
function INDIRECT.EXT won't do as it can't return a range from your
closed workbook. so see the remaining alternatives in:
http://tinyurl.com/2c62u

 

[Guest]

Hello, If you do not need to keep the link open, just do
a copy, paste special, paste values. That removes the
link to the other spreadsheet and enters the data as a
value, not a formula.

 

[Guest]

Thank you...

-----Original Message-----
Hi
INDIRECT does not work on closed workbooks!
There're some alternatives (see link below) But in your case also the
function INDIRECT.EXT won't do as it can't return a range from your
closed workbook. so see the remaining alternatives in:
http://tinyurl.com/2c62u



--
Regards
Frank Kabel
Frankfurt, Germany

hi I need some help.
I'm doing a vlookup grabbing the reference from one cell.
I'm using:

=VLOOKUP(BL$9,INDIRECT("'[Final Detailed
Budget.xls]"&$Z$4&"'!$A$21:$q$33"),$B$7,0)

This works ok when my file (Final Detailed Budget.xls) is
open. But did not work when I close it.

I'm trying writing the entire path:

=VLOOKUP(BL$9,INDIRECT("'H:\Financial
Analysis\Leo\Budget\[Final Detailed Budget.xls]"&$Z$4&"'!
$A$4:$q$16"),$B$7,0)

But this doesn't work either. Can anybody help me...

Thanks

.