Target file for which we want to set define name in the other file |
application/vnd.oasis.opendocument.spreadsheet
|
2021-09-21 14:10:15 UTC |
9.63 KB |
no flags
|
Details |
Attachment cannot be viewed because its MIME type is not text/*, image/*, or application/vnd.mozilla.*.
Download the attachment instead.
File where the defined name and VLOOKUP function should work |
application/vnd.oasis.opendocument.spreadsheet
|
2021-09-21 14:14:53 UTC |
9.59 KB |
no flags
|
Details |
Attachment cannot be viewed because its MIME type is not text/*, image/*, or application/vnd.mozilla.*.
Download the attachment instead.
VLOOKUP works with direct reference to the external document |
image/png
|
2021-09-21 14:15:24 UTC |
59.85 KB |
no flags
|
Details |
VLOOKUP does not work with invalid defined name pointing to external file |
image/png
|
2021-09-21 14:15:46 UTC |
70.43 KB |
no flags
|
Details |