Excel Formulas to Find the Grades with VLOOKUP!!
Tags: excelformula, excelformulas
Published: 2020-12-17 09:46:26

---
title: Excel Formulas to Find the Grades with VLOOKUP!!
published: true
date: 2020-12-17 09:21:28 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-grades-with-vlookup/
---

First, we should understand a little about, What is the **VLOOKUP** function? It is a **Vertical LOOKUP**   function that is used to lookup data in a range or table by row. Today I introduce you to some formulas to **find the grades with the VLOOKUP function in Excel**. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to calculate grades with vlookup](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-calculate-grades-with-vlookup.png)](https://geekexcel.com/excel-formulas-find-grades-with-vlookup/formulas-to-calculate-grades-with-vlookup/#main)<figcaption id="caption-attachment-19902">Formulas to calculate grades with vlookup</figcaption>
## General Formula:

- The below formula is used to find the grades for corresponding scores.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(score,ranges,2,TRUE)**

## Syntax Explanations:

- **VLOOKUP** – The **[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)** means Vertical Lookup. This function is will help to look up the data in a range or table by row.
- **Score** – It represents the criteria value.
- **Input\_Range** – It contains the input values from your worksheet.
- **Number**  **2** – This number will return the column number.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- Let’s see how to assign a letter grade based on the scores.
- Refer to the below image.
- We will enter the input scores and grades in **Column B** and **Column C**.
- Then, enter the given formula in the selected area.
- Finally, it will return the result in **Cell F3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-63.png)<figcaption id="caption-attachment-19901">Example</figcaption>

## Verdict:

In this guide, you can get to know the simple formula to **find the grades of given scores using the VLOOKUP Function in Excel**. Mention your **queries** in the **comment** box below. Thank you. To learn more, check out our website **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[How to Find Vlookup Value Between Two Numbers in Excel?](https://geekexcel.com/how-to-find-vlookup-value-between-two-numbers-in-excel/)**
- **[Vlookup Values From Right and Return Results in the Left Column in Excel](https://geekexcel.com/how-to-vlookup-values-from-right-and-return-results-in-the-left-column-in-excel/)**
- [**How to Vlookup Values from Bottom to Top in Excel 365?**](https://geekexcel.com/how-to-vlookup-values-from-bottom-to-top-in-excel-365/)