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@lists.freedesktop.org
          Reporter: bugzi...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to