Bug ID: 126899
           Summary: Using INDIRECT to define the Array in an HLOOKUP
                    formula fails.
           Product: LibreOffice
           Version: release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc

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,

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

Reply via email to