Miscellaneous lessons from the Expert Skills course. - 03-22 Use a VLOOKUP function for an exact lookup.

This lesson teaches the VLOOKUP function. You'll create a workbook for a classic watch dealer using VLOOKUP functions to manage the product inventory and to create invoices. As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson. ⌚ Timestamps 0:00​ Sample file download instructions, download link, and discussion of sample file. 1:08 Simple explanation of how the VLOOKUP function works. 1:49 Convert a range into a table to comply with VLOOKUP best-practice. 2:43 Give the table a meaningful name to make VLOOKUP easier to work with. 3:00 Insert a VLOOKUP function. 3:37 Lookup_value argument explained and set. 4:03 Table_array argument explained and set. 4:22 Col_index_num argument explained and set. 5:12 Range_lookup argument explained and set (to perform an exact match). 6:00 VLOOKUP tested to prove that it works correctly. 7:27 Link to next lesson, course session playlist and to download sample file set.