Excel Formulas to Calculate the Basic Rates with VLOOKUP!!
Tags: excelformula, excelformulas
Published: 2020-12-17 09:46:42

---
title: Excel Formulas to Calculate the Basic Rates with VLOOKUP!!
published: true
date: 2020-12-17 09:22:27 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-basic-rates-with-vlookup/
---

Sometimes we need to calculate the tax rate based on the amount in one condition. In this article, we will learn How to **calculate the**  **tax rates using the VLOOKUP function in Excel**. Let’s get started!! 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 find the basic rate with vlookup](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-find-the-basic-rate-with-vlookup.png)](https://geekexcel.com/excel-formulas-find-basic-rates-with-vlookup/formulas-to-find-the-basic-rate-with-vlookup/#main)<figcaption id="caption-attachment-19895">Formulas to find the basic rate with vlookup</figcaption>
## Generic Formula:

- Use the below formula to find the basic rate in Excel.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(amount,tax\_table,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 used to look up data in a range or table by row.
- **Amount** – It represents the input amount from your worksheet
- **Tax-Table** – It contains the amount and rate values.
- **Number**  **2** – This number is used to 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 consider the below image to find the base rate.
- First, we will enter the input values in **Column C** and **Column D**.
- Then, enter the given formula in the formula bar section.
- Finally, we will get the results in **Cell G3**.

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

## Bottom-Line:

In this tutorial, we described the simple formula to calculate the Basic rates with the VLOOKUP Function in Excel. If you have any **issue** regarding this article or any unresolved **query,** please comment in the **comment** box below. We will assist you. Thank you so much for reading. To know further updates, keep in touch with our site **[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 find Vlookup and Return the Matching Values from Multiple Worksheets?**](https://geekexcel.com/how-to-find-vlookup-and-return-the-matching-values-from-multiple-worksheets/)