Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You want to identify the student's last name that corresponds when you enter a student ID . In cell B 1 3 , insert the
You want to identify the student's last name that corresponds when you enter a student IDIn cell B insert the INDEX function with a nested XMATCH function. Use the range Students!D$:H$ as the array. The XMATCH function uses the Student ID in cell B$ on the Info worksheet to find the position within the range Students!A$:A$ Use in the Column num argument. Use mixed references as indicated.Copy the function in cell B to cell B In cell B edit the function to change the column number to to retrieve the student's major. Copy the function from cell B to cell B In cell B edit the function to change the column number to to retrieve the student's GPA.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started