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
Financial Ratios Accounting Cycle Accounting Principles Financial Accounting Basics Financial Statements Reporting Bad Debts Current Assets Long-term Assets Voucher System Partnership Depreciation Work Sheet Difference Between Reserve and Fund Accounting for Leases Capital reduction and reconstruction Absorption of Company Amalgamation Accounting for Installment Sales Basis of Recording Profit and Loss Branch Accounting Construction Contracts Revenue Recognition Accounting for Groups Financial Analysis Events After the Balance Sheet Date Deferred Tax Cost Accounting Activity Based Costing (ABC) Throughput Accounting Relevant Cost Break Even Analysis Standard Costing Inventory Management Payroll Accounting Royalty Accounting Statistics Master Budget Salary Income Microsoft Excel Tutorial How to Count Number of Records between Two Dates How to sum values in excel based on a criteria Finding the first login and last logout time of employees How to Print Salary Slips Using VLookup Formula in Excel How to Calculate Net Present Value (NPV) in Excel Income tax calculation excel sheet for salaried individuals How to Calculate Pay Back Period in Excel How to Calculate Declining Balance in Excel Using Formula How to Calculate Double Declining Balance in Excel How to Calculate Number of Payments on A Loan In Excel Using NPER Count the Number of Excel Records That Fall Between Two Dates How to Count Cells between Two Numbers in Excel How to Prepare Exam Result in Excel 3D Sum Multiple Worksheets How to Count Specific Text in Excel Other Topics Share or Stock Valuation Model Financial Management Topics Kinds of Endorsement Letter of Credit, Kinds and Its Advantages/ Utilities Modern Functions of a Commercial Banks Difference Between Secured And Unsecured Loan