In cell M$7,$ create a new XLOOKUP function that looks up the student ID from cell

$17$ and returns the data from the Student Data list. This time, create named ranges

for the lookup$\_$array and the return$\_$array XLOOKUP arguments. Include the eflor

message from Step $2$ if the Student ID is inaccurate.

Test the XLOOKUP function in cell M$7$ by changing the Student ID in cell L$7.$

Page $4$

Manuel Harmon was not able to take the final exam because of car trouble. Manuel

wants to know what grade he needs on the final to getan A in the class. A Class

Average $($cell $124)$ of $92\mathrm{.}0$ wil give Manuel an A for the course. Use Goal Seek to

determine what grade Manuel would need on the final $($cell H$24)$ to get an A for the

course.

EX $3-13$b Using Goal Seek