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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Information Modeling And Relational Databases
Authors: Terry Halpin, Tony Morgan
2nd Edition
0123735688, 978-0123735683
