=vlookup command is not working for me

English
#1

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.

#2

...FALSE()) with empty parentheses.

#3

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

#4

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 7.0.6.2 (x64) on Windows 10.0.

#5

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

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.