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
Text to Columns… -
EDIT: Better answer:
=VLOOKUP(TEXT(W2;"0");$Sheet2.A:B,2,FALSE()), with no need to turn text to number.
Tested with LibreOffice 18.104.22.168 (x64) on Windows 10.0.
please upload your ODF type sample file here instead of the shared images.