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.

Let's say we want to enter data such as Part1, Part2, Part3, Part4, Part5, up to several hundreds (e.g. Part200) with numeric number increment. The following will be what you want to enter: Part1 Part2 Part3 Part4 . . . Part200