Spreadsheet: 885851d1735727807-return-number-from-lookup-several-criterias-book3
Sheet: Sheet1

 | DOW | DAY | AVL | LEI | PKG | OTD | OTA |  | RESERVATION_DATE | CHAR_RESERVATION_DATE | MARKET_CODE_SEQ | MARKET_CODE | MARKET_CODE_DESCRIPTION | S_DEF_ROOMS_DAY | S_DEF_ROOMS_MKT | S_REV_DAY | [NAME]
 | Wed | 2025-01-01 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | CMP | CMP | CMP | 0 | 2 | 0 | 0
 | Thu | 2025-01-02 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | COR | COR | COR | 0 | 0 | 0 | 0
 | Fri | 2025-01-03 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | GCG | GCG | GCG | 0 | 0 | 0 | 0
 | Sat | 2025-01-04 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | GCR | GCR | GCR | 0 | 0 | 0 | 0
 | Sun | 2025-01-05 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | GMG | GMG | GMG | 0 | 0 | 0 | 0
 | Mon | 2025-01-06 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | GSG | GSG | GSG | 0 | 0 | 0 | 0
 | Tue | 2025-01-07 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | GSO | GSO | GSO | 0 | 25 | 0 | 114825.82837723
 | Wed | 2025-01-08 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | HOU | HOU | HOU | 0 | 0 | 0 | 0
 | Thu | 2025-01-09 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | LEI | LEI | LEI | 0 | 34 | 0 | 0
 | Fri | 2025-01-10 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | OTA | OTA | OTA | 0 | 0 | 0 | 0
 | Sat | 2025-01-11 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | OTD | OTD | OTD | 0 | 0 | 0 | 0
 | Sun | 2025-01-12 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | OTH | OTH | OTH | 0 | 0 | 0 | 0
 | Mon | 2025-01-13 00:00:00 | 86 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | PKG | PKG | PKG | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-01-01 00:00:00 | WHO | WHO | WHO | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | CMP | CMP | CMP | 0 | 2 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | COR | COR | COR | 0 | 0 | 0 | 0
 | in E5 = for that date (c5) and the relative code from E4, return the value from P column from Data --> |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | GCG | GCG | GCG | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | GCR | GCR | GCR | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | GMG | GMG | GMG | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | GSG | GSG | GSG | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | GSO | GSO | GSO | 0 | 25 | 0 | 114825.82837723
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | HOU | HOU | HOU | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | LEI | LEI | LEI | 0 | 55 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | OTA | OTA | OTA | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | OTD | OTD | OTD | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | OTH | OTH | OTH | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | PKG | PKG | PKG | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-02 00:00:00 | 2025-01-02 00:00:00 | WHO | WHO | WHO | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | CMP | CMP | CMP | 0 | 2 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | COR | COR | COR | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | GCG | GCG | GCG | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | GCR | GCR | GCR | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | GMG | GMG | GMG | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | GSG | GSG | GSG | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | GSO | GSO | GSO | 0 | 25 | 0 | 114825.82837723
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | HOU | HOU | HOU | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | LEI | LEI | LEI | 0 | 3 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | OTA | OTA | OTA | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | OTD | OTD | OTD | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | OTH | OTH | OTH | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | PKG | PKG | PKG | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-03 00:00:00 | 2025-01-03 00:00:00 | WHO | WHO | WHO | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-04 00:00:00 | 2025-01-04 00:00:00 | CMP | CMP | CMP | 0 | 2 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-04 00:00:00 | 2025-01-04 00:00:00 | COR | COR | COR | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-04 00:00:00 | 2025-01-04 00:00:00 | GCG | GCG | GCG | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 2025-01-04 00:00:00 | 2025-01-04 00:00:00 | GCR | GCR | GCR | 0 | 0 | 0 | 0