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.
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.