From the course: Excel: Lookup Functions in Depth

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Retrieve information by location with the INDEX function

Retrieve information by location with the INDEX function

From the course: Excel: Lookup Functions in Depth

Start my 1-month free trial

Retrieve information by location with the INDEX function

“

- [Instructor] With the INDEX function in Excel, you can extract data from the list based on a row and column reference. On this worksheet called INDEX, we've got a list of items in column I, and they have to be shipped to different zones, and they are of different sizes. This company has boxes of five different sizes here and depending upon where items have to be sent, in other words to different shipping zones, the pricing comes up differently. So for example, in cell L2 here, we've got an item of size five that has to go to zone six so looking at the table to the right, we'd be looking in this column and in this zone entry right here. It's going to be $9 and 15 cents. So, by way of the INDEX function, the function begins with the range of cells that contain the data we're trying to get an extraction from, comma, and we pull out data on the basis of a row first. Which row is it? It corresponds with the zone entry…

Contents