For example, even though the Cavalleria pirate ship is on Excel row 16, it’s actually row 15 in our formula because our range begins on A2 and goes through I16.

VLOOKUP has frustrated me with its rigid limitations and clunky syntax. But, not anymore. I found an Excel fucntion that ...

MATCH searched for "Math" in C2:C9, then passed the result (2) to INDEX, which returned the second element of the array B2:B9, which was New York. So the math major is from New York.