Dec 29 2020 12:20 PM
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?
Dec 29 2020 01:38 PM - edited Dec 29 2020 01:39 PM
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
Dec 31 2020 10:25 PM
Yes, I think my vlookup was giving me incorrect results. A sample file is attached. Thanks for your help.
Jan 01 2021 07:36 AM
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.
Jan 01 2021 08:12 AM