Merging two Excel files using VLOOKUP function is very powerful and convenient for Data Analysis when manual matching of two files is very time consuming because of size of data.