https://bugs.documentfoundation.org/show_bug.cgi?id=149940
Bug ID: 149940
Summary: Incorrect VLOOKUP result
Product: LibreOffice
Version: 7.2.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 181209
--> https://bugs.documentfoundation.org/attachment.cgi?id=181209&action=edit
Spreadsheet demostrating issue
VLOOKUP function that is looking up a date, gives incorrect results for dates
after April 21, 2022.
Please refer to attached spreadsheet. Tab "FX" represents foreign currency
exchange rates for 3 different currencies for each business day (weekends,
holidays etc. are excluded). Everything works as expected up to April 21, 2022
date, and for all subsequent dates, the functions returns the value for April
21, 2022 which is incorrect. Strangely, if 2 rows are skipped, the same
function gives the correct result again. I also observed that if I enter 2 more
dates in tab "FX" as follows:
In cell A752 “Apr 30, 2022”
In cell A753 “May 1, 2022”
Then all VLOOKUP functions start to give the correct result again.
--
You are receiving this mail because:
You are the assignee for the bug.
