Check sibling questions


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)


How to get Hours Worked


How to get Incentive


How to get Department


How to get Employee Code


Get live Maths 1-on-1 Classs - Class 6 to 12

Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 13 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.