Value not available error

[Netzqua]

Hello,

I am trying to apply VLOOKUP but gett the value not available error despite the fact that the value, and lookup value are identical,

i have attached the file to this message,

i have tried changing the format of the cell itself to no avail

any insight would be greatly appreciated

[Jonmo1]

Alas!, they do not match.

This formula
=VLOOKUP(I2,A2:D10,4,FALSE)
is searching column A for the value mathcing I2
But your matching value is actually in column B
So the value in I2 does not exist in column A

Try
=VLOOKUP(I2,B2:D10,3,FALSE)