A viewer wrote to me, asking for help in preparing his company’s payroll statement. I found an Excel Template using the =VLOOKUP() function to help him. In this Excel Video Training lesson, I demonstrate how to effectively use Lookup functions from 2 different worksheets.
Here are the steps to follow in this Excel Video Training Lesson:
- For the 1st part of this lesson I use an Excel Template called Payroll which I downloaded from the MS Excel website.
- The Payroll Statements draw information from two different worksheets via the =VLOOKUP() Function.
- Make sure that your “table arrays” have the key values in the 1st (leftmost) column.
- To return an “exact match” type in FALSE for the 4th argument.
- If you want to copy your =VLOOKUP() formulas, use “Absolute Cell” references for the table array.
Find the Excel Video Training Lesson that you want – Index of all Excel Topics
News! My DVD, “The 50 Best Tips for Excel 2007” is now availabe to purchase. I invite you to visit my online bookstore for more details.
Link to this post!
Dear Sir,
I want to know about Vlook up and Hlook up use in Excel in Payroll. Please guide me.
Hello – Thank you for seeking my help.
Here is a link to one of my many video tutorials demonstrating how to use the VLOOKUP() Function:
http://www.thecompanyrocks.com/use-vlookup-function-to-prepare-a-payroll-statement/
Danny Rocks