Monday March 30, 2015 - Class #19 - Excel Homework #7 - Vloopup, Hlookup, Match and Index

Excel Homework #7 is due Sunday April 5, 2015 at midnight.
Fill out the submission form at the end of the videos on this page.

Directions for Class:

1. Watch Class Video
2. Download Excel data
3. Create a video showing you using Vlookup and Hlookup & MATCH and INDEX functions
4. The class video has the exact homework requirements

CLASS VIDEO

         

                  

This excel homework is about vlookup, hlookup, MATCH and INDEX Excel Functions. This is another way to quickly get data from a data set.

See the Youtube videos below for help.

VLOOKUP FUNCTION VIDEO

http://www.youtube.com/watch?v=eFkGKVjz_ow

HLOOKUP FUNCTION VIDEO

http://youtu.be/5I--h_l0t7U

MATCH & INDEX FUNCTIONS VIDEO

http://youtu.be/Vm8xZzEq7H4