Excel Formulas to Lookup the Lowest Value ~ Easy Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-01-18 04:02:39

---
title: Excel Formulas to Lookup the Lowest Value ~ Easy Tutorial!!
published: true
date: 2021-01-17 10:50:07 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-lookup-lowest-value/
---

So far, we have learned the formulas used to find the **[lowest value in a table](https://geekexcel.com/excel-formulas-find-lowest-n-values/)**. Now here, we come up with the simple and quick steps to **lookup the information associate with the lowest value 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 lookup the lowest value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Formulas-to-lookup-the-lowest-value.png)<figcaption id="caption-attachment-21005">Formulas to lookup the lowest value</figcaption>

## Generic Formula:

- To get the lowest value in a table, you can use the below formula.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(range,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)([MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(values),values,0))**

## Syntax Explanations:

- **INDEX** – In Excel, this function will return the value at a given position in a range or array. Read more on the **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)**.
- **MATCH** – The Excel **[MATCH Function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)** helps to locate the position of a lookup value in a row, column, or table.
- **MIN** – This function will help to return the smallest numeric value from the range of input values. Read more on the **[MIN function](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)**.
- **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.
- **Range** – It represents the input data given in the worksheet.

## Practical Example:

Assume that we have a list of student’s names with their corresponding marks as shown below. Here, we need to find the name of the student who gets the lowest score, and how can we calculate them quickly? Let’s see them below.

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

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

- In this table, we are going to find the name of the student who gets the lowest score.

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

- **[Enter the given formula](https://geekexcel.com/how-to-enter-formula-in-excel/)** in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section or **cell F3**.

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

- Finally, it will return the lowest value information in the selected **[cell](https://geekexcel.com/excel-cells-options/)**.

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

## Conclusion:

From this short article, we have described the steps to lookup the **lowest value information in Excel**. Make use of it. If you have any **queries** related to this article or any other articles on this site, don’t forget to let me know. Click here to learn more on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Sum the Lowest N values from a range with Criteria!!](https://geekexcel.com/excel-formulas-to-sum-the-lowest-n-values-from-a-range-with-criteria/)**
- **[Excel Formulas to Get the Maximum Value with Variable Columns!!](https://geekexcel.com/excel-formulas-maximum-value-with-variable-columns/)**