Merging data using Vlookup

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?

Originally Posted by HRHelp

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?

you need to give details of your data in both sheets with references.