Learn how to use VLOOKUP in the same Excel files or between multiple files. Find out what to do when it's not working.