The INDEX function

In this sample chapter from Microsoft Excel 2019 Data Analysis and Business Modeling, 6th Edition, author Wayne Winston covers the INDEX function. The INDEX function allows you to return the entry in any row and column within an array of numbers. This chapter answers your questions on writing functions and formulas.

Questions answered in this chapter:

  • I have a list of distances between U.S. cities. How do I write a function that returns the distance between, for example, Seattle and Miami?

  • Is there a way I can write a formula that references the entire column containing the distances between each city and Seattle?

Syntax of the INDEX function

The INDEX function allows you to return the entry in any row and column within an array of numbers. The most commonly used syntax for the INDEX function is the following:

INDEX(Array,Row Number,Column Number)

To illustrate, the formula INDEX(A1:D12,2,3) returns the entry in the second row and third column of the array A1:D12. This entry is the one in cell C2.