Tuesday, October 16, 2012

How To... Use the VLOOKUP Function in Excel 2010

My newest video on my Learn with Dr Eugene O'Loughlin YouTube channel is about the VLOOKUP function in Microsoft Excel 2012. Up until today I had never used this function before. However, I am getting students to create a simple Expert System in a tutorial tomorrow and it involves using the VLOOKUP function. If you have two tables in a spreadsheet, VLOOKUP allows you to "look up" values from one  table to another. It can be used for calculating items like tax rates, commissions, mark-ups, etc.

In the video below, I use two simple tables and assign the price of books based on the type (paper/hardback, or eBook) sold. This simple example should explain how to use VLOOKUP at its simplest. 

This is the 80th video on my channel, and I hope that eventually it will clock up a good few views and also make a few euro from advertising. Check it out:

No comments:

Post a Comment