Spreadsheet: 769009d1645249776-multi-criteria-in-index-and-match-questiononindex-and-march
Sheet: NETT_Rate

 |  | Tariff
Hotel | Room Type | From |  | To | 1A | 2A | 3A | 2A1C | ABF | Xb'fast
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-04-01 00:00:00 | - | 2022-04-30 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-05-01 00:00:00 | - | 2022-08-31 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-09-01 00:00:00 | - | 2022-10-07 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-10-08 00:00:00 | - | 2022-10-31 00:00:00 |  |  |  |  | 165 | 0 |  |  | [NAME] (max 6 pax)
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-11-01 00:00:00 | - | 2022-11-30 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-12-01 00:00:00 | - | 2022-12-22 00:00:00 |  |  |  |  | 165 | 0 |  |  | PRICE
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-12-23 00:00:00 | - | 2022-12-29 00:00:00 |  |  |  |  | 165 | 0 |  |  |  | Date | Rate
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-12-30 00:00:00 | - | 2023-01-01 00:00:00 |  |  |  |  | 165 | 0 |  |  | In | 2022-05-01 00:00:00
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2023-01-02 00:00:00 | - | 2023-01-21 00:00:00 |  |  |  |  | 165 | 0 |  |  |  | 2022-04-30 00:00:00
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2023-01-22 00:00:00 | - | 2023-01-27 00:00:00 |  |  |  |  | 165 | 0 |  |  | Out | 2022-05-03 00:00:00
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2023-01-28 00:00:00 | - | 2023-03-31 00:00:00 |  |  |  |  | 165 | 0 |  |  | Total Price
0 | 0 |  |  |  |  |  |  |  |  | 0 |  |  | Total (Night of stay)
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-04-01 00:00:00 | - | 2022-04-30 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-05-01 00:00:00 | - | 2022-08-31 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-09-01 00:00:00 | - | 2022-10-07 00:00:00 |  |  |  |  | 165 | 0 |  |  | How can I also include the criteria of the hotel selection
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-10-08 00:00:00 | - | 2022-10-31 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-11-01 00:00:00 | - | 2022-11-30 00:00:00 |  |  |  |  | 165 | 0 |  |  | The Criteria are
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-12-01 00:00:00 | - | 2022-12-22 00:00:00 |  |  |  |  | 165 | 0 |  |  | Hotel
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-12-23 00:00:00 | - | 2022-12-29 00:00:00 |  |  |  |  | 165 | 0 |  |  | Room Type
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-12-30 00:00:00 | - | 2023-01-01 00:00:00 |  |  |  |  | 165 | 0 |  |  | Valid from
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2023-01-02 00:00:00 | - | 2023-01-21 00:00:00 |  |  |  |  | 165 | 0 |  |  | Price Range
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2023-01-22 00:00:00 | - | 2023-01-27 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2023-01-28 00:00:00 | - | 2023-03-31 00:00:00 |  |  |  |  | 165 | 0
0 | 0 |  |  |  |  |  |  |  |  | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2022-04-01 00:00:00 | - | 2022-04-30 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2022-05-01 00:00:00 | - | 2022-08-31 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2022-09-01 00:00:00 | - | 2022-10-07 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2022-10-08 00:00:00 | - | 2022-10-31 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2022-11-01 00:00:00 | - | 2022-11-30 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2022-12-01 00:00:00 | - | 2022-12-22 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2022-12-23 00:00:00 | - | 2022-12-29 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2022-12-30 00:00:00 | - | 2023-01-01 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2023-01-02 00:00:00 | - | 2023-01-21 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2023-01-22 00:00:00 | - | 2023-01-27 00:00:00 |  |  |  |  | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2023-01-28 00:00:00 | - | 2023-03-31 00:00:00 |  |  |  |  | 165 | 0