Question: In the Rental Data worksheet, in column G, create a formula that uses the HLOOKUP function to assign a group code (A,B, C, D, or
In the Rental Data worksheet, in column G, create a formula that uses the HLOOKUP function to assign a group code (A,B, C, D, or E) from the FurnitureGroups range in the Rental Information worksheet to the furniture listed in colum B.
Rental Data
| Renter | Furniture | Rental Date | Rental Period | Insurance | Shipping Code | Group Code | Rental Fee | Insurance Charge | Shipping Charge | Total Cost |
| Mogan | LR-3pc | 8/15/2017 | 6 | Yes | Pickup | |||||
| Novarre | LR-3pc + | 8/28/2017 | 6 | Yes | Pickup | |||||
| Chico | GR-Electronic | 7/13/2017 | 12 | Yes | Truck | |||||
| Roman | BR-King | 7/17/2017 | 6 | Yes | Truck |
Furniture Group
| Furniture Group | |||||||||
| Furniture | BR-King | BR-Queen | BR-Twin | DR-Table/4 | DR-Table/8 | GR-Pool/Darts | GR-Electronic | LR-3pc | LR-3pc + |
| Group Code | D | C | A | A | D | B | E | C | D |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help