Spreadsheet: 769242d1645433773-indirect-function-with-dv-list-matching-named-ranges-with-_-name-range
Sheet: NameRange

HotelChoice | Hotel
Hotel_Alexandra | Hotel Alexandra |  |  | Hotel Alexandra |  | Best Western PLUS |  | [NAME] |  | [NAME] |  |  | The Kowloon Hotel |  | The Mira |  | The Royal Garden
Best_Western_PLUS | Best Western PLUS |  |  | Diamond / Clover Room (max 2 pax) |  | Standard Room |  | Superior Room |  | 1 King Bed or 2 Twin Beds Room |  |  | Superior Room |  | City Room |  | Superior Room
BP_International_ | BP International |  |  | Heart Room ([NAME] 4 pax) |  |  |  | Deluxe Room |  | 2 King Bed or 2 Twin Beds Room |  |  | Side Harbour View Room |  | Courtyard Room |  | Deluxe Room
Four_Seasons_Hotel | Four Seasons Hotel |  |  | [NAME] (max 6 pax) |  |  |  | Quadruple Room |  | 3 King Bed or 2 Twin Beds Room |  |  |  |  | Parkview Room
Harbour_Grand_Hong_Kong | [NAME] Hong Kong |  |  |  |  |  |  |  |  | 4 King Bed or 2 Twin Beds Room |  |  | [NAME]
[NAME] | [NAME] |  |  |  |  | BP International |  | Harbour Plaza North Point |  | 5 King Bed or 2 Twin Beds Room |  |  | Superior Room |  | The [NAME] |  | Royal Pacific Hotel
Harbour_Plaza_8_Degrees | [NAME] |  |  |  |  | Run-of-House |  | Superior City View Room |  | 6 King Bed or 2 Twin Beds Room |  |  | Deluxe Room |  | Superior (Room Size: 38 SQM) |  | [NAME]
Harbour_Plaza_North_Point | Harbour Plaza North Point |  |  |  |  | [NAME] |  | Superior Side Harbour View Room |  | 7 King Bed or 2 Twin Beds Room |  |  | [NAME] |  | N1 Deluxe (Room size: 47 SQM) |  | Tower Wing - Pacific Grand Room
Hyatt_Regency_Tsim_Tsui_Tsui | Hyatt Regency Tsim [NAME] |  |  | When I name the above |  | Family room |  |  |  | 8 King Bed or 2 Twin Beds Room |  |  |  |  | N2 Grand (Room size: 50 SQM)
Hyatt_Centric_Victoria_Harbour | [NAME] |  |  |  |  |  |  |  |  | 9 King Bed or 2 Twin Beds Room |  |  | [NAME]
The_Kowloon_Hotel | The Kowloon Hotel |  |  | Ctrl+Shift+F3 |  | Four Seasons Hotel |  | Hyatt Regency Tsim [NAME] |  | 10 King Bed or 2 Twin Beds Room |  |  | Superior Room |  | New World Millennium
Marco_Polo_Hong_Kong_Hotel | [NAME] |  |  | it automatically make the name as |  | Deluxe Peak View Room (room size: 45 sqm) |  | 1 King Bed / 2 Twin Beds |  | 11 King Bed or 2 Twin Beds Room |  |  | Deluxe Room |  | Superior Room
Gateway_Hotel | [NAME] |  |  | Hotel_Alexandra |  | Deluxe Harvour View Room (room size: 45 sqm) |  | 2 King Bed / 2 Twin Beds |  | 12 King Bed or 2 Twin Beds Room |  |  | Premier Room |  | Deluxe Room
Metropark_Hotel_Kowloon | Metropark Hotel Kowloon |  |  |  |  |  |  | 3 King Bed / 2 Twin Beds |  | 13 King Bed or 2 Twin Beds Room |  |  |  |  | [NAME]
The_Mira | The Mira |  |  |  |  | [NAME] |  | 4 King Bed / 2 Twin Beds |  | 1 King Bed Harbour View or 2 Twin Beds Harbour Room |  |  | Metropark Hotel Kowloon
The_Murray | The [NAME] |  |  |  |  | Superior Room |  | 5 King Bed / 2 Twin Beds |  | 2 King Bed Harbour View or 2 Twin Beds Harbour Room |  |  | Superior Room |  | The Park Lane Hong Kong,
New_World_Millennium | New World Millennium |  |  | Hotel Alexandra |  | Courtview Room / Tower Cityview Room |  | 6 King Bed / 2 Twin Beds |  | 3 King Bed Harbour View or 2 Twin Beds Harbour Room |  |  | Deluxe Room |  | Superior Room
The_Park_Lane_Hong_Kong, | The Park Lane Hong Kong, |  |  | Heart Room ([NAME] 4 pax) |  | Tower Harbourview Room |  | 7 King Bed / 2 Twin Beds |  | 4 King Bed Harbour View or 2 Twin Beds Harbour Room |  |  |  |  | Deluxe Room
The_Royal_Garden | The Royal Garden |  |  |  |  | Harbourview Room |  | 8 King Bed / 2 Twin Beds |  | 5 King Bed Harbour View or 2 Twin Beds Harbour Room |  |  |  |  | Family Room
Royal_Pacific_Hotel | Royal Pacific Hotel |  |  |  |  |  |  | 9 King Bed / 2 Twin Beds |  | 6 King Bed Harbour View or 2 Twin Beds Harbour Room
 |  |  |  |  |  | [NAME] Hong Kong |  | 1 King Deluxe / 2 Twin Deluxe |  | 7 King Bed Harbour View or 2 Twin Beds Harbour Room
 |  |  |  |  |  | Superior Harbourview Room |  | 2 King Deluxe / 2 Twin Deluxe |  | 8 King Bed Harbour View or 2 Twin Beds Harbour Room
 |  |  |  |  |  | Deluxe Harbourview Room |  | 3 King Deluxe / 2 Twin Deluxe |  | 9 King Bed Harbour View or 2 Twin Beds Harbour Room
 |  |  |  |  |  |  |  | 4 King Deluxe / 2 Twin Deluxe |  | 10 King Bed Harbour View or 2 Twin Beds Harbour Room
 |  |  |  |  |  |  |  | 5 King Deluxe / 2 Twin Deluxe |  | 11 King Bed Harbour View or 2 Twin Beds Harbour Room
 |  |  |  |  |  |  |  | 6 King Deluxe / 2 Twin Deluxe |  | 12 King Bed Harbour View or 2 Twin Beds Harbour Room
 |  |  |  |  |  |  |  | 7 King Deluxe / 2 Twin Deluxe |  | 13 King Bed Harbour View or 2 Twin Beds Harbour Room
 |  |  |  |  |  |  |  | 8 King Deluxe / 2 Twin Deluxe
 |  |  |  |  |  |  |  | 9 King Deluxe / 2 Twin Deluxe
 |  |  |  |  |  |  |  | 1 King Harbour View / 2 Twin Harbour View
 |  |  |  |  |  |  |  | 2 King Harbour View / 2 Twin Harbour View
 |  |  |  |  |  |  |  | 3 King Harbour View / 2 Twin Harbour View
 |  |  |  |  |  |  |  | 4 King Harbour View / 2 Twin Harbour View
 |  |  |  |  |  |  |  | 5 King Harbour View / 2 Twin Harbour View
 |  |  |  |  |  |  |  | 6 King Harbour View / 2 Twin Harbour View
 |  |  |  |  |  |  |  | 7 King Harbour View / 2 Twin Harbour View
 |  |  |  |  |  |  |  | 8 King Harbour View / 2 Twin Harbour View
 |  |  |  |  |  |  |  | 9 King Harbour View / 2 Twin Harbour View