See how to create INDEX formula, and use the INDEX function with the MATCH function
Use the Excel function INDEX with MATCH and MIN, to show the name of the store that has the lowest price. The lowest price is calculated by the MIN function, and MATCH locates that price in the row. The INDEX function returns the store name for the selected column.
For written instructions for this Excel INDEX function tutorial, see the Contextures Blog article: Find Best Price with Excel INDEX and MATCH
The INDEX function can return a value or reference to a value, so you can use it to:
For written instructions for this Excel INDEX function tutorial, see the Contextures Blog article: 30 Excel Functions in 30 Days: 24 -- INDEX
Last updated: July 10, 2021 8:32 PM