Bug 126899 - Using INDIRECT to define the Array in an HLOOKUP formula fails.
Summary: Using INDIRECT to define the Array in an HLOOKUP formula fails.
Status: RESOLVED DUPLICATE of bug 126898
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.0.4 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-08-13 22:09 UTC by bugzilla
Modified: 2019-08-13 23:25 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
shows vlookup functioning with indirect, and hlookup not working. (12.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-08-13 22:10 UTC, bugzilla 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description bugzilla 2019-08-13 22:09:50 UTC 
Description:
I have a VLOOKUP formula, [ =VLOOKUP(G2,INDIRECT(F2),2,0) ], where F2 varies, but is a named range. This formula works.

When I try the same with HLOOKUP, [ =HLOOKUP(G17,INDIRECT(F17),2,0) ] the INDIRECT fails. If I put the name of the Range directly into the formula, it works, however if I try to do it where the name of the Range is in F17, failure...

Actual Results:
HLOOKUP with INDIRECT returns Err:502

Expected Results:
Should be the same as VLOOKUP


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 bugzilla 2019-08-13 22:10:35 UTC 
Created attachment 153364 [details]
shows vlookup functioning with indirect, and hlookup not working.
Comment 2 m_a_riosv 2019-08-13 23:25:00 UTC 

*** This bug has been marked as a duplicate of bug 126898 ***