Understand the VLOOKUP function.

The VLOOKUP function in a spreadsheet program searches for a value in the first column of a table array and returns a value in the same row from a column you specify.
The syntax is: VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• lookup_value: The value to search for (e.g., "Gold", "Silver", "Bronze").
• table_array: The range of cells containing the data (Table 2 in this case).
• col_index_num: The column number in the table_array from which to return the value (e.g., 2 for Bonus%).
• range_lookup: FALSE for an exact match, TRUE for an approximate match. We need an exact match here.

• The lookup_value will be the "Trainer Level" for each trainer from Table 1.
• The table_array will be Table 2, which contains "Trainer Level" and "Bonus%". This range should be absolute (e.g., $G$2:$H$4 if Table 2 starts at G2) so it doesn't change when the formula is copied.
• The col_index_num for "Bonus%" in Table 2 is 2 (since "Trainer Level" is column 1 and "Bonus%" is column 2).
• The range_lookup will be FALSE because we need an exact match for the trainer level.

Assuming "Trainer Level" for Nkosi is in cell E2 and Table 2 (Trainer Level and Bonus%) is in the range G2:H4: $\text{=VLOOKUP(E2, \$G\$2:\$H\$4, 2, FALSE)}$ When this formula is applied to each trainer, it will look up their respective "Trainer Level" in Table 2 and return the corresponding "Bonus%".

• Nkosi (Gold): VLOOKUP("Gold", Table2, 2, FALSE) returns 20%
• Ava (Silver): VLOOKUP("Silver", Table2, 2, FALSE) returns 10%
• Noah (Bronze): VLOOKUP("Bronze", Table2, 2, FALSE) returns 5%
• Olivia (Gold): VLOOKUP("Gold", Table2, 2, FALSE) returns 20%
• Vusi (Silver): VLOOKUP("Silver", Table2, 2, FALSE) returns 10%
• Caleb (Bronze): VLOOKUP("Bronze", Table2, 2, FALSE) returns 5%

The bonus percentages for each trainer are:

• Nkosi: 20%
• Ava: 10%
• Noah: 5%
• Olivia: 20%
• Vusi: 10%
• Caleb: 5%

The final answer is \boxed{\text{=VLOOKUP(E2, \G$2:$H$4, 2, FALSE)}}$ (assuming E2 is the first trainer's level and G2:H4 is Table 2).