DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

Excel Formulas to Lookup the Lowest Value ~ Easy Tutorial!!

So far, we have learned the formulas used to find the lowest value in a table. 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

Formulas to lookup the lowest value
Formulas to lookup the lowest value

Generic Formula:

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

=INDEX(range,MATCH(MIN(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.
  • MATCH – The Excel MATCH Function 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.
  • 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 B and Column C.

Input Ranges
Input Ranges

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

Criteria
Criteria

Enter a formula
Enter a formula

  • Finally, it will return the lowest value information in the selected cell.

Result
Result

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!! *and Excel Formulas *!!

Related Articles:

Top comments (0)