Question: 5 . On the Enrollment worksheet, in cell A 1 3 , insert a table using range A 1 3 :D 1 0 6 and
On the Enrollment worksheet, in cell A insert a table using range A:D and the top row as the headers In cell D enter an HLOOKUP function that will look up the class number in cell B and will use the Classinfo table to return the Fee from the fifth row of the table with an exact match In cell E create a new column header named Class Name. In cell E enter an HOOKUP function that will look up the class number in cell B and use the Classinfo
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
