VLOOKUP migration from Ms.Excel to LibreOfficeCalc
 

I have a Ms.Excel file that I used for months in Windows. Since now I am using Linux, I move from Excel to Calc. There is a VLOOKUP formula in that file that doesn't work on Calc.

It only returns #VALUE! I've read about VLOOKUP in Calc and what the #VALUE error code means, tried some solutions such as changing the cell format but it is still unable to work. What should I do to make that formula work as how it worked in Windows?

Thanks