a$.$ Type LACR $-46$ in cell B$2$ and insert the MATCH function in cell B$3$ to look up the Sponsor ID in cell B$2,$ compare it to the list in the range D$8$:D$43,$ and then return the sponsor$$s position within the list.

$$

b$.$ Insert an INDEX function in cell B$4$ that uses the range D$8$:K$43,$ looks up the row position number from the MATCH function result, and then uses the column position number for Full Name.

$$

c$.$ Insert an INDEX function in cell B$5$ that uses the range D$8$:K$43,$ looks up the row position number from the MATCH function result, and then uses the column position number for Scholarship. Format the value as Accounting Number Format with zero decimal places.