Ask Your Question

lookup function between 2 files

asked 2019-08-30 05:12:09 +0100

sherly tedjo gravatar image

I use lookup function between 2 files and it works fine. But after i close the file and open it again, the link won't be updated and so I got error message #NAME?

what should i do?

edit retag flag offensive close merge delete


From LibreOffice error codes page:

Code 525 #NAME?
Message invalid names (instead of Err:525 cell contains #NAME?)
Explanation An identifier could not be evaluated, for example, no valid reference, no valid domain name, no column/row label, no macro, incorrect decimal divider, add-in not found

Please show the lookup formulas causing the error message.

Opaque gravatar imageOpaque ( 2019-08-30 15:26:06 +0100 )edit


sherly tedjo gravatar imagesherly tedjo ( 2019-09-04 02:45:31 +0100 )edit

What's your LibreOffice version? Apparently you saved in OOXML .xlsx format and it looks like you were hit by some bug fixed already.

erAck gravatar imageerAck ( 2019-09-05 18:49:33 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-09-04 12:26:07 +0100

Opaque gravatar image

updated 2019-09-04 12:26:51 +0100


your VLOOKUP() doesn't refer to a second file, but a sheet named [4]baru within the same document, which in turn is an invalid sheet name, since sheet names may not contain the characters [ ] * ? : / \ or the character ' (apostrophe) as first or last character. This clearly explains why you got a #NAME? error.

I'd expect something like


PS: The ! separating sheetname from range makes me assume, that you got the formula from an Excel document.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-30 05:12:09 +0100

Seen: 345 times

Last updated: Sep 04 '19