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 a value for the optional range_lookup argument.

A) HLOOKUP(A5, H4:I11, 2, FALSE)
B) VLOOKUP(A5, H4:I11, 1, FALSE)
C) VLOOKUP(A5, H4:I11, 2, TRUE)
D) LOOKUP(A5, H4:I11)

Answer 1

The correct formula using the VLOOKUP function to find the cost per participant based on the workshop ID in cell A5 is VLOOKUP(A5, H4:I11, 2, FALSE), which looks for an exact match in the first column and returns the value from the second column. The correct answer is B) VLOOKUP(A5, H4:I11, 1, FALSE).

Step-by-step explanation:

In cell D5, to determine the cost per participant for the Game Room workshop based on the workshop ID in cell A5 using the VLOOKUP function and the range H4:I11 as the lookup table, the correct formula would be:

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

This formula indicates that the function should search for the workshop ID from cell A5 within the first column of the range H4:I11, and then return the value from the second column of that range which corresponds to the cost per participant.

The 'FALSE' parameter specifies that the function should look for an exact match of the workshop ID. As we omit the optional range_lookup argument, or explicitly set it to FALSE, VLOOKUP will not approximate match and will only return the cost if a precise match for the ID is found in the table.