Ask Your Question

Vlookup got Err:502 [closed]

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

lolax gravatar image

updated 2020-08-23 11:40:44 +0100

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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-23 11:41:12.890467

1 Answer

Sort by » oldest newest most voted

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

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 +0100 )edit

Question Tools

1 follower


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

Seen: 2,037 times

Last updated: Aug 04 '15