# Learn How to Calculate Grades With VLOOKUP in Microsoft Excel

Written by | 0 Comments | 358 Views

In this article, you will learn how to evaluate things based on the LOOKUP function in Microsoft Excel using a single/combination(s) of functions. You will also know to Calculate Grades With VLOOKUP and see the generic formula.

Learn How to Calculate Grades With VLOOKUP in Microsoft Excel

The main purpose of this formula is to assign a grade based on a score. Here we will learn how to calculate grades with VLOOKUP in the given data range in the workbook in Microsoft Excel. That implies, with the help of a formula based on the VLOOKUP function you can able to assign a grade based on a score. So, with the help of this formula, you can able to calculate grades with VLOOKUP in the given data range in the workbook in Microsoft Excel.

General Formula to Calculate Grades With VLOOKUP

=VLOOKUP(score,key,2,TRUE)

The Explanation to Calculate Grades With VLOOKUP

So we know that with the help of the given formula above you can able to assign a grade based on a score. Here we will learn how to calculate grades with VLOOKUP in the given data range in the workbook in Microsoft Excel. As we know that the approximate match mode VLOOKUP assumes the table is sorted by the first column. The score provided as a lookup value, the function will scan the first column of the table. If it finds an exact match, it will return the grade in that row. If it doesn't find an exact match, it will continue scanning until it finds a value greater than the lookup value, and "step back", and return the grade in the previous row. So now you have learned how to calculate grades with VLOOKUP in the given data range in the workbook in Microsoft Excel.