Spreadsheet: 769086d1645283485-multi-criteria-in-index-and-match-questiononindex-and-march
Sheet: NETT_Rate

 |  | Tariff
 |  |  |  |  |  |  |  |  |  |  |  |  | =INDEX(Range_2,MATCH(1,(from=checkin)*($A$4:$A$26=$N$6)*($B$4:$B$26=$N$7),0),MATCH($O$9,$F$3:$I$3,0))
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 | 1273 | 1365 | 1370 | 1396 | 165 | 0
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-05-01 00:00:00 | - | 2022-08-31 00:00:00 | 1213 | 1456 | 1108 | 1216 | 165 | 0
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-09-01 00:00:00 | - | 2022-10-07 00:00:00 | 1188 | 1185 | 1400 | 1015 | 165 | 0 |  | Hotel
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-10-08 00:00:00 | - | 2022-10-31 00:00:00 | 1113 | 1055 | 1061 | 1009 | 165 | 0 |  | Room Type | Diamond / Clover Room (max 2 pax)
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-11-01 00:00:00 | - | 2022-11-30 00:00:00 | 1420 | 1102 | 1398 | 1016 | 165 | 0
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-12-01 00:00:00 | - | 2022-12-22 00:00:00 | 1440 | 1147 | 1155 | 1293 | 165 | 0 |  | Price | PRICE | 2A
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-12-23 00:00:00 | - | 2022-12-29 00:00:00 | 1087 | 1492 | 1342 | 1163 | 165 | 0 |  |  |  | Date | Rate
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2022-12-30 00:00:00 | - | 2023-01-01 00:00:00 | 1457 | 1121 | 1233 | 1453 | 165 | 0 |  | CheckIn | In | 2022-09-01 00:00:00 |  | Should be 1188
Hotel Alexandra | Diamond / Clover Room (max 2 pax) | 2023-01-02 00:00:00 | - | 2023-01-21 00:00:00 | 1288 | 1472 | 1405 | 1194 | 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 | 1427 | 1136 | 1297 | 1159 | 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 | 1251 | 1198 | 1305 | 1426 | 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 | 1012 | 1097 | 1041 | 1069 | 165 | 0
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-05-01 00:00:00 | - | 2022-08-31 00:00:00 | 1002 | 1123 | 1420 | 1058 | 165 | 0
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-09-01 00:00:00 | - | 2022-10-07 00:00:00 | 1446 | 1218 | 1016 | 1252 | 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 | 1222 | 1293 | 1306 | 1285 | 165 | 0
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-11-01 00:00:00 | - | 2022-11-30 00:00:00 | 1473 | 1191 | 1066 | 1275 | 165 | 0 |  |  | The Criteria are
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-12-01 00:00:00 | - | 2022-12-22 00:00:00 | 1291 | 1205 | 1199 | 1446 | 165 | 0 |  |  | Hotel
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-12-23 00:00:00 | - | 2022-12-29 00:00:00 | 1481 | 1365 | 1036 | 1042 | 165 | 0 |  |  | Room Type
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2022-12-30 00:00:00 | - | 2023-01-01 00:00:00 | 1000 | 1304 | 1120 | 1241 | 165 | 0 |  |  | Valid from
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2023-01-02 00:00:00 | - | 2023-01-21 00:00:00 | 1268 | 1032 | 1015 | 1233 | 165 | 0 |  |  | Price Range
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2023-01-22 00:00:00 | - | 2023-01-27 00:00:00 | 1203 | 1088 | 1288 | 1154 | 165 | 0
Hotel Alexandra | Heart Room ([NAME] 4 pax) | 2023-01-28 00:00:00 | - | 2023-03-31 00:00:00 | 1307 | 1329 | 1234 | 1072 | 165 | 0
0 | 0 |  |  |  | 1132 | 1376 | 1037 | 1225 |  | 0 |  |  | How to get 1188
Hotel Alexandra | [NAME] (max 6 pax) | 2022-04-01 00:00:00 | - | 2022-04-30 00:00:00 | 1295 | 1317 | 1225 | 1418 | 165 | 0 |  | Step | We select the following step by step
Hotel Alexandra | [NAME] (max 6 pax) | 2022-05-01 00:00:00 | - | 2022-08-31 00:00:00 | 1068 | 1493 | 1114 | 1190 | 165 | 0 |  | 1 | Hotel
Hotel Alexandra | [NAME] (max 6 pax) | 2022-09-01 00:00:00 | - | 2022-10-07 00:00:00 | 1482 | 1262 | 1277 | 1233 | 165 | 0 |  | 2 | Room type
Hotel Alexandra | [NAME] (max 6 pax) | 2022-10-08 00:00:00 | - | 2022-10-31 00:00:00 | 1010 | 1190 | 1191 | 1196 | 165 | 0 |  | 3 | Price Type
Hotel Alexandra | [NAME] (max 6 pax) | 2022-11-01 00:00:00 | - | 2022-11-30 00:00:00 | 1105 | 1367 | 1466 | 1132 | 165 | 0 |  | 4 | Date
Hotel Alexandra | [NAME] (max 6 pax) | 2022-12-01 00:00:00 | - | 2022-12-22 00:00:00 | 1067 | 1344 | 1186 | 1428 | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2022-12-23 00:00:00 | - | 2022-12-29 00:00:00 | 1020 | 1004 | 1266 | 1316 | 165 | 0 |  |  | formula to help to find the closer figure
Hotel Alexandra | [NAME] (max 6 pax) | 2022-12-30 00:00:00 | - | 2023-01-01 00:00:00 | 1146 | 1461 | 1474 | 1371 | 165 | 0 |  |  | In this case is 1188
Hotel Alexandra | [NAME] (max 6 pax) | 2023-01-02 00:00:00 | - | 2023-01-21 00:00:00 | 1212 | 1404 | 1375 | 1028 | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2023-01-22 00:00:00 | - | 2023-01-27 00:00:00 | 1076 | 1215 | 1044 | 1219 | 165 | 0
Hotel Alexandra | [NAME] (max 6 pax) | 2023-01-28 00:00:00 | - | 2023-03-31 00:00:00 | 1169 | 1175 | 1375 | 1477 | 165 | 0