Question: In cell E5, add a VLOOKUP function to look up the student's uniform size in the Student_Data table for the student listed in cell 132.

 In cell E5, add a VLOOKUP function to look up the

In cell E5, add a VLOOKUP function to look up the student's uniform size in the Student_Data table for the student listed in cell 132. The function should be looking for an exact match. In cell E7, add a HLOOKUP function to retrieve the student's registration fee in the Entry_Fee named range for the registration type in cell E3. The function should be looking for an exact match. In cell [13, add a COUNTIF function to count the number of uniforms in the Uniform_Size column of the Student Data table that meet the filter criteria in cell H12

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!