Thanks shg. I got the formula to work by increasing the range of the match functions and following the correct row and column order in the INDEX function.
Thanks again for the help.
Here is the formula that ultimately worked
=INDEX($G$6:$P$44, MATCH($C$6,$G$6:$G$45,0), MATCH($C$7,$G$6:$Q$6,0))
Bookmarks