MS Excel VLOOKUP function for approximate data

Smoke Studios

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

Transcript

00:00Over here I have a table data in descending order as you can see right here where it represents the

00:06grades of students. So over here I have 56 and let's say I want to use VLOOKUP to go ahead and

00:12assign a grade to it. So for that I can press equals and type in VLOOKUP right here just like

00:18this. Open up the bracket and select the source content, press comma and then select out the

00:24table right here and I want the grade which is on the second column so I'm just going to

00:29press 2 and I want this range but not exact marks so any range is fine. So I'm just going to go ahead

00:35and type in TRUE for that and then go ahead and close the bracket, press ENTER and then 56 is a D

00:41as you can see right here because it is more than 50. So if I were to go ahead and set A, 80 then that's

00:48A, 81 is A right here because it is more than 80 and then 65 is C and 35 is F just like this as you can

00:57see.

Category

Transcript

Comments

Recommended