MS Excel VLOOKUP function for approximate data

visibility 7 views schedule 11 months ago timer 0:58
open_in_new Dailymotion
In this tutorial, we will learn how to use the VLOOKUP function in Excel for approximate matches. You will understand how to set the range_lookup argument to TRUE, apply it for finding ranges such as grades, commission rates, and pricing slabs, and see how Excel returns the closest match when exact data is not available.<br /><br />This lesson is part of our complete Microsoft Excel tutorial series for beginners.<br /><br />#Excel #VLOOKUP #ExcelTutorial