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

Sometimes you don’t want to search for an exact match but are interested in the nearest match. This is called an inexact lookup. Consider the following exam grades: 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. 0:10 Discussion of the Excel VLOOKUP function's Range_lookup argument. 1:00 Inexact match and Exact match discussed in the context of the sample file. 1:45 Vital importance of ascending order sort of lookup value stressed. 2:03 Expectation of inexact match results discussed. 2:52 Convert the lookup range into a lookup table to confirm with VLOOKUP best practice. 3:20 Give the newly created table a meaningful name' 3:51 Add a VLOOKUP function to the worksheet. 4:09 Set the Lookup_value, Table_array, Col_index_num and Range_lookup arguments. 5:27 Link to next lesson, course session playlist and to download sample file set.