Sometimes VLookup functions don’t act how you want. It’s not the function that is wrong though, it’s usually the data. One common error with Vlookups are trying to pull data that doesn’t match because of spaces. You may have a group of data that has an extra space at the end or the beginning. It’s just something that happens sometimes because of the way you import or export data.
To get around this issue, we can use the TRIM function. This function will take all unwanted spaces out of words. It will still leave the normal spaces where they should be. However it will fix up the word so that it will then match.
I made a video below to help explain this.