Excel Formulas to Lookup the Values between Two Numbers!!
Tags: excelformula, excelformulas
Published: 2021-01-18 04:05:30

---
title: Excel Formulas to Lookup the Values between Two Numbers!!
published: true
date: 2021-01-17 10:56:10 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/lookup-values-between-two-numbers-excel/
---

In this chapter, we are going to see how to **lookup the values between two numbers** and return a corresponding result. To achieve this you can use the given Excel formula based on the LOOKUP function. Let’s get into this article!! 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)

[![Lookup the value between two numbers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Lookup-the-value-between-two-numbers.png)](https://geekexcel.com/?attachment_id=21059#main)<figcaption id="caption-attachment-21059">Lookup the value between two numbers</figcaption>

## Generic Formula:

- Use the below formula to look up the value.

**=[LOOKUP](https://geekexcel.com/use-lookup-function-in-microsoft-excel-365-simple-methods/)(cell, minimums, results)**

## Syntax Explanations:

- **LOOKUP** – The [**LOOKUP Function**](https://geekexcel.com/use-lookup-function-in-microsoft-excel-365-simple-methods/) in Excel performs an approximate match lookup in a one-column or one-row range and returns the corresponding value from another one-column or one-row range.
- **Cell** – It is the cell where you want to show the result.
- **Minimum** – It is the minimum value, that helps to find the result.
- **Result** – It is the fixed value that is to be found.
- **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.

## Practical Example:

Let’s see how to find the value between two numbers.

- First, we will give the input Marks in **[Column](https://geekexcel.com/excel-office-365-columns/) B**.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Range-7.png)<figcaption id="caption-attachment-21060">Input Range</figcaption>

- We have assigned the criteria between the two values in **Column E** and **Column F**.

![Criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Criteria-10.png)<figcaption id="caption-attachment-21061">Criteria</figcaption>

- Now, we want to find the result based on the input marks.
- So, enter the given formula in Cell C3, you can also see the formula in the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section.

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula-10.png)<figcaption id="caption-attachment-21062">Enter the formula</figcaption>

- Finally, click the **ENTER** key to get the results.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-27.png)<figcaption id="caption-attachment-21063">Result</figcaption>

## Wind-Up:

From this short tutorial, we have described the simple formula used to **lookup the values between two numbers in Excel**. Make use of it. Please state your queries in the below comment section let me know. We will assist you. To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Get the Nth Matching Value Using VLOOKUP Function!!](https://geekexcel.com/excel-formula-nth-value-vlookup/)**
- **[Formulas to Lookup a Value and Return a Different Cell From the Table!!](https://geekexcel.com/formulas-to-lookup-a-value-and-return-a-different-cell-from-the-table/)**