Using vlookup across multiple columns

[Shenique1690]

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?

[#2]

@Shenique1690 

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

[#3]

@adversi

Yes, I think my vlookup was giving me incorrect results. A sample file is attached. Thanks for your help. 

[#4]

@Shenique1690 

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.

[#5]

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