Using vlookup across multiple columns

New Contributor

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


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.

You can learn in this short video what causes the VLOOKUP to result in errors and how to quickly and accurately fix them.