$8$ Based on the projected revenue in column I, you want to determine each room's projected room classification.

In cell J$6,$ using a lookup function, enter a formula to determine the projected room classification based on the projected quarterly revenue after renovations in cell I$6.$ Use the named range RoomClassification when entering this formula.

Copy this formula through cell J$10.$

$12$