Vlook Up function not working Properly, donot know, need help

Either you can try the formula mentioned above or you can convert the text into number in Sheet 5-Column A. By doing that, the formula which you had used, will get you result as you looking for.

Let me know if it works for you.

thanks Sixthsense

it worked great, I learn some thing new,

thank you very much

Adhawan06

how did you say I fix this arrow this also

use -before the column that will fix the arrow

its nice to know these tricks

thanks again