Forum Discussion
Using vlookup across multiple columns
I have two files that I need to compare. I need to match up the account number and payment amounts between the two files to identify what's causing differences between the two files. How can I do a vlookup given the above?
4 Replies
- You can learn in this short video what causes the VLOOKUP to result in errors and how to quickly and accurately fix them.
https://www.youtube.com/watch?v=r0IClYkK3rs Can you provide a sample dataset to get a better scope of the project (with no confidential data) -- some alternatives solutions would be to use INDEX/MATCH or PowerQuery since VLOOKUP carries some risk to return wrong figures
Yes, I think my vlookup was giving me incorrect results. A sample file is attached. Thanks for your help.
See attached the VLOOKUP reference in Column G of the File 1 tab. Any #N/As are because the account number does not exist in File 2.
