using text in a formula

A

AlexD

I'd like that the FileName reflects a text from the first
column of the same row.

=VLOOKUP($E$1,C:\Path\[FileName.XLS]Sheet1'!e,2,FALSE)

I've tried

=VLOOKUP($E$1,C:\Path\[CELL("contents", A1).XLS]Sheet1'!
e,2,FALSE)

but it's not working.

Could you advise anything?

Thanks
 
F

Frank Kabel

Hi
if the other workbook is opened use the following formula
=VLOOKUP($E$1,INDIRECT("'[" & A1 &".xls]Sheet1'E1:D100"),2,FALSE)

Note: This won't work with a closed workbook!
 
A

AlexD

Thanks a lot, Frank.
But, I need to do it with a closed workbook.

Alex
-----Original Message-----
Hi
if the other workbook is opened use the following formula
=VLOOKUP($E$1,INDIRECT("'[" & A1 &".xls] Sheet1'E1:D100"),2,FALSE)

Note: This won't work with a closed workbook!


--
Regards
Frank Kabel
Frankfurt, Germany

I'd like that the FileName reflects a text from the first
column of the same row.

=VLOOKUP($E$1,C:\Path\[FileName.XLS]Sheet1'!e,2,FALSE)

I've tried

=VLOOKUP($E$1,C:\Path\[CELL("contents", A1).XLS]Sheet1'!
e,2,FALSE)

but it's not working.

Could you advise anything?

Thanks
Click to expand...
.
Click to expand...
 
Top