Ask Your Question
0

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

Comments

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

=VLOOKUP(D8,[4]baru!$b$1:$I$65255,8,0)

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
0

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

Opaque gravatar image

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

Hello

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

VLOOKUP(D8,'file:///<path_to_your_secondfile>'#$<sheetname>.$B$1:$I$65255,8,0

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

Stats

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

Seen: 58 times

Last updated: Sep 04