Bug 33426 - Lookup function Err:504 when search/result vectors are from separate file
Summary: Lookup function Err:504 when search/result vectors are from separate file
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.0 RC4
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Kohei Yoshida
Whiteboard: target:3.4
: 33588 (view as bug list)
Depends on:
Reported: 2011-01-24 12:41 UTC by Bill Kirby
Modified: 2011-03-16 10:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Zip file containing spreadsheet samples and screenshot image (85.32 KB, application/zip)
2011-01-24 12:41 UTC, Bill Kirby

Note You need to log in before you can comment on or make changes to this bug.
Description Bill Kirby 2011-01-24 12:41:51 UTC
Created attachment 42404 [details]
Zip file containing spreadsheet samples and screenshot image

This problem occurs on both my Ubuntu Linux (64 bit) and in Windows XP SP3.

When trying to use a separate file that contains the search and result vectors the function fails with an Err:504. If I place my search/result sheet within the same workbook and try the Lookup formula again, it will work. This function worked fine in OpenOffice. Sometimes I may get a Err:511. I usually save my files in .xls format but tried .ods format and got the same results.

I've attached sample sheets of what I'm working with. My criterion is from B column in main.xls and my search is from B column in search-result.xls and result is C column of search-result.xls. I've also added a screenshot of the Lookup dialog window showing the error.
Comment 1 GerardF 2011-01-27 08:08:13 UTC
*** Bug 33588 has been marked as a duplicate of this bug. ***
Comment 2 Kohei Yoshida 2011-03-03 14:39:05 UTC
Indeed, LOOKUP, HLOOKUP and VLOOKUP all had to be adjusted in order for them to handle external references correctly.

Hopefully this is fixed for good.
Comment 3 Luis Thiago 2011-03-16 10:20:21 UTC
This error still has been occurring with this functions and other functions (IF, SUMIF, COUNTIF...) in external references. And all functions created by "Function Wizard" gives error, the external references aren't inserted on the function.

LibreOffice 3.3.1 
OOO330m19 (Build:8)
tag libreoffice-
Comment 4 Kohei Yoshida 2011-03-16 10:31:49 UTC
It's fixed in 3.4.  Look at the target info.