https://bugs.documentfoundation.org/show_bug.cgi?id=149940
LeroyG <iavs.le...@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|FIXED |NOTABUG --- Comment #3 from LeroyG <iavs.le...@gmail.com> --- The fourth parameter of the VLOOKUP function must be set to 0 if there are dates missing. Use =VLOOKUP($A1,$FX.$A$2:$FX.$D$1048576,4,0) FX page are missing days 23 and 24. 22/04/2022 25/04/2022 And 30/04/2021 is duplicated. -- You are receiving this mail because: You are the assignee for the bug.