So far, we have seen how to get the closest match in Excel. Here, we will show the simple formula that assists you to match the next highest value in Excel. 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
Generic Formula:
- Use the below formula to match the next highest value in Excel.
=INDEX(data,MATCH(lookup,values)+1)
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.
- 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.
- Data – It represents the input data given in the worksheet.
- Values – It is one of the input ranges.
- Lookup – It represents the criteria.
- Plus operator (+) – This symbol is used to add the values.
Example:
Let’s see the below example image to know how to get the next highest value in Excel.
- First, we will give the input values in Column B and Column C.
- Enter the given formula in cell F4 , you can also see the formula in the formula bar section.
- Then, press the ENTER key.
- Now, we will get the desired output in the selected cell.
Verdict:
From this tutorial, you can get some clarification on how to match the next highest value in Excel Office 365. I hope this article is useful to you. If you have any queries, don’t forget to let me know. Keep learning on Geek Excel!! *and Excel Formulas *!!
Top comments (0)