4 In column H create a formula using the IF and VLOOKUP func

4. In column H, create a formula using the IF and VLOOKUP functions to calculate the rental
charges for each set of furniture based on the furniture’s group code, the rental period, and the
Furniture Rental Charges table. (Hint: For the IF function arguments, use one VLOOKUP function
for 3 months and another for 9 months. The defined name RentalCharges has been assigned to
the Furniture Rental Charges table.)

Solution

Since we have to use only IF AND VLOOKUP functions to Calculate the Rental Charges for each set of furnoture based on

1. Furniture group Code
2. The Rental Period
3. Furniture Rental Charges Table

The rental charges are broken down into 3 and 9 months and are in different colum , SO we have to use IF condition here so that VLOOKUP can access from different column.

Three Cases:
1. If the Rental Period is 3 , Lookup using the Furniture group code and rental period and Access 2nd Column
2. If the Rental Period is 9 , Lookup using the Furniture group code and rental period and Access 3rd Column.
3. Otherwise FALSE

So the final Excel formula is
= VLOOKUP([@[ Furniture group code]],Furniture Rental Charges,IF([@[Furniture Rental Period]]=3,2,3),FALSE)