Excel 2007 : To copy data from one sheet to another using VLookup

[AswathyCG]

I have a doubt on VLookup function.For eg sheet1 have names of 20 persons and sheet 2 also contains names of 25 names of which sheet 1 and sheet 2 have 5 names in common. I want to copy the names of sheet 1 to sheet 2 which is not in sheet2. How can I copy the names using VLookup?

[teylyn]

maybe Vlookup is not the function you need. Post a workbook and explain your expected results in context.