Bug 163028 - 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 DUPLICATE of bug 141989
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:58 UTC by MikeR
Modified: 2024-09-18 15:30 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
selects month number from month list (18.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-09-18 15:00 UTC, MikeR 		Details
View All 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:58:15 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
Device Lenovo E14
Comment 1 MikeR 2024-09-18 15:00:56 UTC 
Created attachment 196524 [details]
selects month number from month list
Comment 2 Buovjaga 2024-09-18 15:23:07 UTC 
*** Bug 163027 has been marked as a duplicate of this bug. ***
Comment 3 Mike Kaganski 2024-09-18 15:28:59 UTC 

*** This bug has been marked as a duplicate of bug 141989 ***
Comment 4 Mike Kaganski 2024-09-18 15:30:29 UTC 
The exact same thing is discussed/explained also in tdf#144229, tdf#149832.