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
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 Basic Salary
How to get Hours Worked
How to get Incentive
How to get Department
How to get Employee Code