Google Spreadsheet-VLOOKUP does not take all characters??

VLOOKUP only take some characters, why not all?
In column G:J marked in color it does not take.
I tried also with "IF formula" only but cant get it worked either

https://docs.google.com/spreadsheets...it?usp=sharing


VLOOKUP.png

The values in col E are all text, whereas some of the values in cols A:D are numbers.
Not sure if this works in sheets, but try

Formula:

Please Login or Register  to view this content.

It didnt worked. I tried to change all "X" to 3 instead but still not working

Some of the the values in col E are still text

Glad it's sorted & thanks for the feedback.