Bug 163027 - Vlookup results are inorrect results for some rows in a 2 column x 12 row array of months
Summary: Vlookup results are inorrect results for some rows in a 2 column x 12 row arr...
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.5.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-09-18 14:56 UTC by MikeR
Modified: 2024-09-18 16:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 MikeR 2024-09-18 14:56:47 UTC 
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
Comment 1 Buovjaga 2024-09-18 15:23:07 UTC 

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