Skip to content

video not played or not found error
click on direct switch

Hosted by Dailymotion. For legal issues: Copyright Center · DMC · Instant Removal

MS Excel VLOOKUP function for approximate data

S
Smoke Studios

55 Views • Sep 06, 2025

Description

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.

This lesson is part of our complete Microsoft Excel tutorial series for beginners.

#Excel #VLOOKUP #ExcelTutorial