In cell F4, create a formula using the HLOOKUP function to determine the Cost per participant for the workshop based on the Workshop ID in cell C4. Use range ter B16:E17 as the lookup table, and the Cost per participant listed in row 2 of the lookup table. Do not enter a value for the optional range_lookup argument. How to do in excel

Question

In cell F4, create a formula using the HLOOKUP function to determine the Cost per participant for the workshop based on the Workshop ID in cell C4. Use range ter B16:E17 as the lookup table, and the Cost per participant listed in row 2 of the lookup table. Do not enter a value for the optional range_lookup argument. How to do in excel

Answer 1

To accomplish this in Excel, you can use the following formula in cell F4:

=HLOOKUP(C4, B16:E17, 2)

This formula will search for the Workshop ID in cell C4 within the range B16:E17 and return the corresponding Cost per participant from row 2 of the lookup table. Since we did not specify a value for the range_lookup argument, Excel will default to an exact match.