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
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.
- In this table, we are going to find the name of the student who gets the lowest score.
- Enter the given formula in the formula bar section or cell F3.
- Finally, it will return the lowest value information in the selected cell.
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 *!!
Top comments (0)