Summary of What I Did

• Data validation to ensure correct data formats (e.g., dates, currency, remote score, ⭐ rating)
• Dropdown for Room Type, Cancellation, Desk, Noise Level, Breakfast, Loyalty Program, Gym, Early Check, Green Score, ⭐ Rating
• Use of formulas such as ARRAY_CONSTRAIN, ARRAYFORMULA, INDEX, MATCH, MAX, and TEXT to get the Recommended Hotel (Highest Score)
• Using IMAGE to get the photo linked from the hotels' website
• Conditional formatting to see which hotel got the highest score
• Wrapping text to make the entries readable
• Protected ranges to safeguard formulas while keeping data entry frictionless
• Clean currency formatting throughout for readability
• Formatting on table headings