For some reason VLOOKUP is returning #N/A.
This file was working perfectly fine last time i used it.
I had upgraded to libre office 6.2, but even when i down grade back to LO6.1 the VLOOKUP still isnt working ?
The same file opened in open-office works correctly.
Very strange as I havent changed anything in the file
EDIT: The problem seems to fix itself if i start editing values by deleting trailing white spaces in the lookup field for example. Once the formula starts working again I can re-add the trailing whitespaces and everything is still fine.