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