From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

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

Retrieving information by location

Retrieving information by location

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Retrieving information by location

“

- [Voiceover] A specialized kind of function is called Index. The index function allows us to pull data out of a list based on a row and column reference. We've got a table over here on the left-hand side, perhaps something like you might've seen at a post office, packages that get shipped to different zones have higher rates depending upon the zone, maybe the size of the package, maybe this is based on pound range that we're not seeing at the moment, but we've got different rates here. Over in columns P, Q, and R, we've got lots of entries and each of these entries, identified by a code number, but also with the size and a shipping zone. We want to know what the shipping cost is for each one of these, so for example on the very first entry here, if we're looking at an item of size five, we'd be looking in row seven over here, we'd be looking at these numbers right here, and if it's in shipping zone four, we'd be looking at the entries in column F right here, so where they intersect…

Contents