https://bugs.documentfoundation.org/show_bug.cgi?id=163027
Bug ID: 163027
Summary: Vlookup results are inorrect results for some rows in
a 2 column x 12 row array of months
Product: LibreOffice
Version: 24.2.5.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
=VLOOKUP(A16,$A$2:$B$13,2)
Produces incorrect results
Steps to Reproduce:
1.Setup table Month name in calendar order/month number
2.Setup list of Key value (month names)
3.lookup value in adjacent cells
Actual Results:
=VLOOKUP(A16,$A$2:$B$13,2)
January 1
February 2
March 3
April 4
May 5
June 2
Jul 2
August #N/A
September 9
October 8
November 8
December #N/A
Expected Results:
January 1
February 2
March 3
April 4
May 5
June 6
July 7
August 8
September 9
October 10
November 11
December 12
Reproducible: Always
User Profile Reset: No
Additional Info:
OS Linux Ubuntu 24.04.02
Rebooted and no change occured
--
You are receiving this mail because:
You are the assignee for the bug.
