Question

In cell B4, insert an INDEX function that uses the range D8:K35, looks up the row position number from the MATCH function result, and then uses the column position number for Full Name.

Answer 1

Sure, here’s the formula you can use in cell B4:

=INDEX(D8:K35, MATCH("Full Name", D8:K8, 0), MATCH(B3, D8:D35, 0))

Make sure to replace B3 with the cell reference containing the row position number from the MATCH function result.