I have a list of distances between U.S. cities. How do I write a function that returns the distance between, say, Seattle and Miami?
Is there any way I can write a formula that references the entire column containing the distances of each city to Seattle?
The INDEX function allows you to return the entry in any row and column within a rectangular array of numbers. The most commonly used syntax for the INDEX function is:
INDEX(Array, Row Number, Column Number)
To illustrate, the formula INDEX(A1:D12,2,3) would return the entry in the second row and third column of the array A1:D12. This entry is the one in cell C2.