I was told that Vlookup can be used for merging worksheet. I have two diferent files with similar data. What both files have in common is name, number, location. How can I use Vlookup to merge this two files. Does anyone know how it can be done?