Download file: https://excelisfun.net/files/ExcelBasics.xls
Download file: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/ExcelBasics.xls
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#23 Video topics:
1)VLOOKUP function formula
2)Data Validation List
3)VLOOKUP for Exact Match
4)VLOOKUP for Approximate Match
5)Lookup Product Price: Exact Match
6)Lookup Tax Amount: Approximate Match

Also see these videos:
Excel Lookup Series #1: VLOOKUP Function 1st Example
Excel Lookup Series #2: VLOOKUP Function 2nd Example