Transposing and ranking

You will now use INDEX() and MATCH() combo to deal with another complicated two-dimensional lookup!

Did you know that this powerful function combo can also be used when we are dealing with a transposed table? In other words, we can perform an INDEX/MATCH lookup even if the rows and columns are swapped. You will see it's very handy when trying to rank the US States in the following exercise.

One more time, here is the syntax! Pay good attention to the order of the two MATCH() functions (rows, then columns)!