Contextures

Excel INDEX Function Videos

See how to create INDEX formula, and use the INDEX function with the MATCH 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

More Videos

Excel Videos - Index

Macros

Mouse Shortcuts

Pivot Table Tips

Names

Paste Special

Create UserForms

Copy VBA

 

Last updated: October 31, 2018 11:05 AM
Contextures RSS Feed