Created attachment 144340 [details] vlookup vlookup report incorrect value. Please look at the attathcment , I'm not a native English speaker , please forgive me for my bad English.
There is not issue, you have forgotten the fourth parameter, please take a look to the help. https://help.libreoffice.org/6.1/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152