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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching the formula (not the value) for a text string 1
Vlookup and return sheet name also 2
add hyperlink using sheet names and cells(i,j) 3
If equation with a VLookUp 3
Merging from an Excel file with graphics 1
combine three if functions 3
Conditional Hyperlinking 0
Split cells next to 1 cell 1

Top