The INDEX$/$ MATCH formula below returns a #REF $!$ error. Why?

$=$INDEX$(\{"$UConn$",$ "Tennessee", $"$S$.$ Carolina"$\},$ XMATCH$("$McGraw$",\{"$Auriemma$",$ "Summitt", "Staley", "McGraw"$\}))$

The formula cannot use only array constants; it must reference at least one cell on the worksheet

Using INDEX$/$MATCH only works when the items within the lookup$\_$array and the return$\_$array are identical values.

The lookup$\_$array must be sorted alphabetically

The row$\_$num $($INDEX$\text{'}$s second argument$)$ is larger than the length of the return$\_$array

There cannot be any special characters in the return$\_$array, but $"$S$.$ Carolina" has a period