The match function has the advantage of having flexibility in returning a location. The output no longer has to be a fixed number of columns or rows away from some kind of starting place. So for instance, if I had the names Andrew, Barbara, and Charlie in the list, I wanted to work out which one Andrew was, match would work out that that was the first one. If I wanted his work out which one Charlie was, the match function would work out that was the third one, and would return that number three. You can then use that three in an index function and offset function or a choose function. To go through the function, here it says match lookup value. So my lookup value could be the words best case. It then it asks you for lookup array. Where do you want to look? And we could be looking in B8 to B10, which has best case, base case, and worst case. It then asks you, do you want to match type? So that's optional. That's where you can look for a match, which is less than, greater than, or exactly what you are looking for. So if you were looking for the number 50, you could look for any values which are less than 50 or greater than 50 or exactly 50. Seeing as we're looking for text, we would choose the exact match. So in this example, we look for best case, best case is in cell C4. We then look for that within B8 to B10, and it sees that it is the first one and returns and number one.