If an exact match is found, MATCH returns the relative row number for that match.
you’re able to use INDEX to retrieve individual values, or entire rows and columns.
MATCH supports approximate and exact matching, andwildcards(* ?)
INDEX and MATCH descending order
To retrieve values from a table where lookup values are sorted in descending order [Z-A] you can use INDEX and MATCH, with MATCH configured for approximate match using a match type of -1. In the example shown, the formula in F5 is: =INDEX(C5:C9,MATCH(F4,B5:B9,-1)) where values in B5:B9 are sorted in descending order. Context Suppose you have a product that is sold in rolls of 100 feet, and orders are allowed in whole rolls only. For example, if you need 200 feet of material, you need two rolls total, and if you need 275 feet, you'll need to buy three rolls. In this case, you want the formula to return the "next highest" tier whenever you cross over an even multiple of 100.
