11
In cell I14, add a MATCH function nested in an INDEX
10
function to retrieve the uniform fee located in the
Uniform_Fee table on the Data Inputs worksheet that
meet the filter criteria in cells H12 and I13. For the
quantity, use a less than match. For the size, use an
exact match.
To prevent an error from displaying when no uniforms of
the size located in H12 are needed, nest the INDEX and
MATCH functions inside an IFERROR function to leave
the cell blank.
12
In cell B12, use the VLOOKUP function to retrieve the
student’s first name 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 B12
down to B17.
6