In this lesson, we're going to look at using the index function. And the index functions purpose is to tell us a value within a position within a column or row or a mix of a group range here. So let's just start off and just do a quick index just off the side here. Because it's kind of a two part scenario here, we need the array. So here's my array, and this scenario here. And now I need a road number.

Now, if I were to tell it just to go down five, it's going to look at the first one US, Australia, Brazil, Canada, Dominican Republic will go down five, I hit Enter, I get the Dominican Republic there. Well, that's not too useful all by itself using the index function. You can see here, if I told it to go down eight, I'm going to get Germany it's the eighth one here. The idea here is you can use the index function with the match function to get some real value. There. So in this scenario, I've got the country codes, I would like to know what country they are, well, a V lookup would normally be the way to go.

But the problem here is our codes are to the right of what we're trying to return. So we want to use the index function with the match function combined. So it would look like this equals index. My array will be the absolute reference of these countries hit for absolute reference that on a PC, comma, and the row number is going to be looking at these country codes and find this parallel right next to it. So match. Looking up, in this case, J two, we're going to find it within this group here, absolute reference that and my match type is going to be zero because for an exact match when I close it out Going to get the Dominican Republic.

Copy it down further. And those are all the values looking up each code here. Pretty cool. So in this case it went down to the 900 and returned Great Britain there.