I recently recorded a handful of videos for my Complete Microsoft Excel course and thought I would share these videos. I've placed them in a YouTube playlist to make is accessible in order to go through each.
The videos include working with Excel's VLOOKUP, HLOOKUP and the INDEX and MATCH functions.
Please download the exercise file to follow along with the video: Excel103-AdvLOOKUPExercises.XLSX