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