VLOOKUP Error with IF function

Hi! I'm having an issue with the file I'm working on - basically how the file works is that you paste a raw data dump from a database and since it has various amounts of random spaces in the cell va...