Question

In cell D5, create a formula using the VLOOKUP function to determine the cost per participant for the Game Room workshop based on the Workshop ID in cell A5. Use range H4:I11 as the lookup table and the cost per participant listed in column 2 of the lookup table. Do not enter value for the optional range_lookup argument.

Answer 1

To determine the cost per participant for the Game Room workshop based on the Workshop ID in cell A5, you can use the VLOOKUP function in cell D5 using range H4:I11 as the lookup table and the cost per participant listed in column 2 of the lookup table.

Step-by-step explanation:

To determine the cost per participant for the Game Room workshop based on the Workshop ID in cell A5, you can use the VLOOKUP function in cell D5. The VLOOKUP function searches for a value in the first column of a lookup table and returns the corresponding value from a specified column. In this case, you need to use the range H4:I11 as the lookup table and the cost per participant listed in column 2 of the lookup table.

The formula you can use in cell D5 is:

=VLOOKUP(A5, H4:I11, 2, FALSE)

This formula will search for the Workshop ID in cell A5 in the first column of the lookup table and return the corresponding value from the second column, which is the cost per participant for the Game Room workshop.