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!