# Excel Video Tutorials INDEX Function

## Find Best Price With Excel INDEX and MATCH

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

## Excel INDEX Function Examples

The INDEX function can return a value or reference to a value, so you can use it to:

• Find sales amount for selected month
• Get reference to specified row, column, area
• Create a dynamic range based on count
• Sort column of text in alphabetical order

For written instructions for this Excel INDEX function tutorial, see the Contextures Blog article: 30 Excel Functions in 30 Days: 24 – INDEX

 Excel Video Tutorials 01 Excel Video Tutorials 02 Excel Video Tutorials 03 Excel Video Tutorials 04 Excel Video Tutorials 05 Excel Video Tutorials 06 Excel Video Tutorials 07 Excel Video Tutorials 08  Excel Video Tutorials 09  Excel Video Tutorials 10