[Libreoffice-bugs] [Bug 126899] New: Using INDIRECT to define the Array in an HLOOKUP formula fails.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126899

            Bug ID: 126899
           Summary: Using INDIRECT to define the Array in an HLOOKUP
                    formula fails.
           Product: LibreOffice
           Version: 6.3.0.4 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bugzilla at gairsty.com

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:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190813/9af72906/attachment.html>