Search on two worksheets in Excel

[shaleen7]

Hi All,

I need some help. I have a workbook with 3 worksheet. Two of the worksheet contains a table of information. The common column between the two worksheets is name. I would like to be able to search on the name column in both worksheets and return the row of information that is associated with that name. I would like the 3rd worksheet to be the search page because the information on the other two worksheets is supposed to be confidential. I've attached a sample file.

I am sorry to say I am not at all familiar with VLookup.

Any help or suggestions would be greatly appreciated.

Cheers!

 

[SkipVought]

Hi,

There is no Name column in Data1!

Please be sure that your data example is coherent!