Ask Your Question

Vlookup got Err:502

asked 2015-08-04 17:48:25 +0200

lolax gravatar image

updated 2015-08-26 11:35:04 +0200

Alex Kemp gravatar image

LibreOffice 4.3.7 I have three xls files, the first file vlookup the second file, and the second file vlookup the third file, it's working from MS Excel, but it fails from Libreoffice Calc.

C:\fakepath\first.xls C:\fakepath\second.xls C:\fakepath\third.xls

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-08-04 18:25:47 +0200

erAck gravatar image

Works for me with LibreOffice 4.3.7 and 4.4.5 if I load second.xls and answer the question whether links to other files should be updated with Yes. first.xls has a different absolute path, once corrected also that one works. Btw, I got a #N/A error first instead of Err:502 (which would be illegal argument).

edit flag offensive delete link more


I still get Err:502. If the value gets from regular value, then everything is okay, but if the value is from other vlookup, then it fails.

lolax gravatar imagelolax ( 2015-08-05 02:42:41 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-08-04 17:48:25 +0200

Seen: 1,924 times

Last updated: Aug 04 '15