In cell C12, use the VLOOKUP function to retrieve the
student’s last name in the Student_Data table that meet
the filter criteria in cell A12 . The value should be looking
for an exact match. Copy the formula in C12 down to
C17.
13
In cell D12, use the VLOOKUP function to retrieve
whether or not the student has a permission slip on file
in the Student_Data table that meets the filter criteria in
cell A12 . The value should be looking for an exact
match. Copy the formula in D12 down to D17.
In cell E12, use the VLOOKUP function nested in an IF
function to retrieve the student’s uniform size. To
prevent zeros from being displayed when the uniform
size is not known, nest the VLOOKUP function in an IF
function to leave the cell blank when the skill level
equals 0. The value should be looking for an exact
match. Copy the formula in E12 down to E17.
5