Excel VLOOKUP issue

Solution 1:

In the last parameter of your VLOOKUP, you are using 1, which is equivalent to TRUE, which tells VLOOKUP to use an approximate match. Change it to 0 or FALSE.