I’m facing a very annoying issue with vlookup in Calc that I can’t solve. vlookup returns wrong results with certain lists, no matter on what system or Windows version (I tried 3 different).
I’ve read tons of post here about and elsewhere about bad vlookup results, included everything about the famous sort order parameter. Using a sorted or unsorted list with the relative parameter the result are wrong.
I also tried to remove all bad characters form list(s) like normal and square brackets and dots.
I also disabled “allow regular expressions in formulas”. Anything solve the problem.