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. Walter Hickey ...

Index, Match, and Index Match. In Excel, the INDEX function returns an item from a specific position (in a list, table, database). The MATCH function returns the position of a value (in a list ...