# How to Print Salary Slips Using VLookup Formula in Excel

In large organizations, the office staff and labour are found in huge quantity. In order to keep track of their attendance up to date is not an easy task. If the number of employees touches thousand, then it become the headache of the human resource staff to process the salaries and print the slips.

Lets suppose that ABC is a shoe manufacturing concern. It has around 2,000 employees, following is the extract from its Excel Payroll sheet maintained in Sheet 1:

 S. NO Name Employee ID Basic Salary Over time Total Salary 1 Ahmed 001 30,000 3,000 33,000 2 Salman 002 25,000 2,000 27,000 3 Jagdesh 003 35,000 1,000 36,000 4 Kiran 004 20,000 5,000 25,000 5 Jose 005 28,000 4,000 32,000 6 Allan 006 22,000 6,000 28,000 7 Martin 007 23,000 7,000 30,000

Now, we will prepare payroll slips using the Vlookup fucntion in excel in Sheet 2 using the formula shown below:

The result of the above formula will print the result as follows:

Here, we just input the S. No of each row record in C2 cell, then the formuloa will fetch up all the data based on the value of C2 in Sheet 1. We entered 2, 3, 4, 5 & 6 to tell the Ms Excel that from which column, the formula retrieves the result. VLOOKUP is invaluable Micrsoft Excel Formula which speeds up the genjeration of various types of reports.

Contents