https://bugs.documentfoundation.org/show_bug.cgi?id=149940
--- Comment #11 from slavaf2...@gmail.com --- Further to my previous comment, considering that the other spreadsheet that I have has a similar set up and is experiencing a the same issue, I suspect the VLOOKUP function breaks down when the referenced lookup range is large (in my case all the way to the bottom of the spreadsheet in the attached spreadsheet, and smaller but still large in my second spreadsheet), but the values to look up stop somewhere within this range (i.e. the lookup range is not filled with values entirely and there are empty cells in the bottom portion of the lookup range). It seems to work fine up until the last few rows that are filled in, and after than it just seems to stop looking further, and is returning a value close to the end of these filled rows, but it's not the right value. As a temporary workaround, if I enter a couple more dates in sequence at the end, then the function starts to give correct results. I think there must be some kind of an offset that is preventing looking up values all the way to the end of the filled out range. That is my suspicion based on the behavior. Play around with the spreadsheet as I described and you will see it for yourself! -- You are receiving this mail because: You are the assignee for the bug.
