Learn How to Get Values in Descending Order in Microsoft Excel
The main purpose of this formula is to retrieve values from a table where lookup values are sorted in descending order. Here we will learn how to get values in descending order in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the INDEX and MATCH functions, you can able to retrieve values from a table where lookup values are sorted in descending order.
So, with the help of this formula, you can able to get values in descending order in the given data range in the workbook in Microsoft Excel.
General Formula to Get Values in Descending Order
=INDEX(range1,MATCH(lookup,range2,-1))
The Explanation to Get Values in Descending Order
So we know that with the help of the given formula above, you can able to retrieve values from a table where lookup values are sorted in descending order.
Here we will learn how to get values in descending order in the given data range in the workbook in Microsoft Excel. As we know, the MATCH function is used to find the first value in the B column that is greater than or equal to the lookup value.
If an exact match is found, MATCH returns the relative row number for that match. When no exact match is found, MATCH continues through the values in B columns until a smaller value is found, then it “steps back” and returns the previous row number.
So now you have learned how to get values in descending order in the given data range in the workbook in Microsoft Excel.