Buon giorno,
As far as I can see, everything is OK in the sample you posted. ( I am using OpenOffice though and this might explain it)
BUT, all the values in col A are text values ( preceded by an apostroph) while the values in col B are numbers. You can verify this with the TYPE() function eventually.

It so happens that when XL compares two contents it first compares their TYPE. If they are not the same, XL returns FALSE

If you need to keep text values in col A as is try =VLOOKUP(value(A1),b1:C1000,2,0)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post