Compare two excels with multiple columns using macros

[suresh_kumar4 (suresh kumar)]

Hi Guys,

I have 2 excel files with many columns. i want to compare all the columns in 2 excels…and update the match and unmatch result in any of the column…

i need the vlookup formula for this. can any one help me out please…

Thanks,
Suresh.