Retrieving information by location with INDEX

- Excel's Index function allows us…to pull information out of a table or a range of cells,…based on a row reference and a column reference.…In this worksheet, called Index,…we've got a table off to the left.…Perhaps something like you might see at a post office.…Based on the size of a package and where it's being shipped,…we've got a different cost.…So, imagine a package that is a size 3.…Maybe that's based on weight…or some other kind of dimension.…We're going to get some kind of pricing from this row.…If it's shipped to zone 6,…then we're going to get a price of 35.29,…because here's the shipping zone right here.…

So, it'd be 35.29, if it's size 3…and going to shipping zone 6.…Over in columns L, M, and N, we've got a list of items…of various sizes that need to go…to different shipping zones.…We see that in column N and we need…to calculate the shipping cost.…Of course in situations like this, sometimes this list…is on a different worksheet, but in this case…it's on the same worksheet as the table…that we need to refer to.…