Understand the VLOOKUP function.

To add the bonus percentage for each trainer using the VLOOKUP function, you would typically add a new column to Table 1. Step 1: 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. Step 2: Identify the components for the VLOOKUP. • 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., G2:H4 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. Step 3: Construct the VLOOKUP formula for the first trainer (Nkosi). Assuming "Trainer Level" for Nkosi is in cell E2 and Table 2 (Trainer Level and Bonus%) is in the range G2:H4: =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%". Step 4: Apply the formula to all trainers to get their bonus percentages. • 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 =VLOOKUP(E2, \G\2:\H\4, 2, FALSE) (assuming E2 is the first trainer's level and G2:H4 is Table 2). Send me the next one 📸