<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=539359806247306&ev=PageView&noscript=1"/>

 Assignment

Data is given in different sheets about location,salary,employee,department etc

We have to fill Employee Master Sheet from taking data from all these sheets

Use of Vlookup - Vlookup

 

Download File and Try

 

 

How to do

When both sheets are in same order,we can also use Simple Links or Copy Paste.

However,if both sheets are in different order,we have to use vlookup

V lookup is normally used for compiling or bringing data from one sheet to another.

 

Formula of Vlookup

= Vlookup(Select item, Go to Other Sheet Select Area and Press F4 , Write Column No .of Area, 0)vlcsnap-00013.jpgvlcsnap-00013.jpg

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com.
Didn't understand? Ask your question or doubt free.

Apna sawal puchiye!

Jail