cell contents instead of a file name

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
 
Top