On your VLOOKUP formula, you've used the fourth argument, TRUE which stands for Approximate Match. Well, if your data isn't sorted you won't get your expected results. So, better you look for the exact match. So use FALSE instead of TRUE.
Here's the updated formula: