hello there, I need to access to this file located on a nas server with vlookup
\qnap\archivio…ods
VLOOKUP($J24;INDIRECT("'file:///\qnap\archivio…ods is correct?
what’s the right “path” I have to write in to the formula? I have win7.
I get that path in “LoadURL” toolbar thanx
Open the qnap file.
Copy any cell.
Open your local file.
Ctrl+Shift+V (paste-special)
Check “Link”.
The result is a reference to the copied cell in the other file.
Adjust your formula without using INDIRECT.
Thanx, tomorrow I’ ll try.
The problem is that I have 1 file for every day called 01032022.ods 02032022.ods etc.
and I need access every one to retrieve some data and via indirect() on local files all works fine, but I don’t know how setup if the files is are on a nas (qnap), I got the path with reverse slash and no letter…
today I tried “file:///\qnap\archivio…ods” with no result.
thanx
You have to use correct URL format, backslash is not a path delimiter but forward slash is, so
"file:///qnap/archivio...ods" if that drive is mounted in a /qnap directory, or whatever the paste-as-link gave you.
1 Like