=vlookup command is not working for me

I am trying to use =vlookup to get values from something and it isnt working. I am trying to get the VTDST,C,6 column’s values but it doesn’t work. Please tell me what I am doing wrong.

...FALSE()) with empty parentheses.

I tried =VLOOKUP(W2,$Sheet2.A:B,2,FALSE()) if that’s what you mean, it still shows #N/A

Sheet2 content is text, not numbers.

Select columns A and B, change cell category to Number, then choose menu Data - Text to Columns… - OK.

EDIT: Better answer: =VLOOKUP(TEXT(W2;"0");$Sheet2.A:B,2,FALSE()), with no need to turn text to number.

Tested with LibreOffice (x64) on Windows 10.0.

please upload your ODF type sample file here instead of the shared images.