Vlookup with multiple sheets

[Praveen Kumar SIngh]

Hi Chandoo,

Suppose there is three sheets given with emp name, salary, emp name, empid, and empname, emp experience.if i want to retrieve the data in sheet four using emp name which is common to all the places using nested functions. i tried with vlookup but i have to write the formula thrice to retrieve the data. is it possible to use vlookup with match or index with match to retrieve all columns data in sheet 4. please help me in this.

Kindly don't use VBA or macro. i need to understand in excel.

Regards,
Praveen Kumar Singh

 

[bosco_yip]

Hi,

Uploaded your file with around 10 lines example data together with the expected result.

Regards
Bosco

 

[Nightlytic]

If you have headings Name, Salary, ID and Experience, that spans 4 columns, you will need 3 formulas (vlookups, index&matches) no matter how you approach it. One formula can't populate multiple cells.

I will echo Bosco and say you should upload a file, but also tell us why 3 vlookups are inappropriate in your scenario. Performance? Presentation? It seems like the most straight-forward solution anyway.