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:111 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. How to do in excel
To create a formula using the VLOOKUP function in cell D5 to determine the cost per participant for the Game Room workshop, follow these steps:
1. Select cell D5 in your Excel worksheet.
2. Type the following formula:
`=VLOOKUP(A5, H4:I111, 2, FALSE)`
In this formula:
- A5 represents the Workshop ID for the Game Room workshop.
- H4:I111 is the range that contains the lookup table, with Workshop IDs in column H (column index 1) and cost per participant in column I (column index 2).
- 2 is used as the column index to retrieve the cost per participant.
- FALSE is used as the range_lookup argument to ensure an exact match is found for the Workshop ID.
3. Press Enter to complete the formula.
The formula will search for the Workshop ID in cell A5 within the specified range and return the corresponding cost per participant for the Game Room workshop in cell D5.