I think the problem is the character "~" which Excel seems to treat wrong for your formula.

To handle the ~ character correctly in your VLOOKUP formula, you need to "escape" it by adding another ~ in front of it "~~". This tells Excel to treat the ~ as a literal character and not as a special character.

Or replace it with an empty string or another character.