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 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
Get step-by-step solutions from verified subject matter experts
