Spreadsheet: 839584d1692100476-xlookup-advanced-problem-excel-problem
Sheet: Product Price

Product code | AB1234
Product model year | 2024
Value date | 2023-08-15 00:00:00
 | Code | Full price | Combined price | Excel formula | Combined code |  |  |  | Product code | Product model year | Code | Combined code | Price | Valid from | Valid To
 | AA | 1200 | 0 |  |  |  |  |  | AB1234 | 2023 | AA |  | 1000 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 | AC | 70 | 70 |  |  |  |  |  | AB1234 | 2023 | AA | BA | 0 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 | AD | 2000 | 1400 |  |  |  |  |  | AB1234 | 2023 | AB |  | 500 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 | BA | 5100 | 5100 |  |  |  |  |  | AB1234 | 2023 | AC |  | 50 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 | BB | 800 | 800 |  |  |  |  |  | AB1234 | 2023 | AD |  | 1900 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 | BD | 60 | 60 |  |  |  |  |  | AB1234 | 2023 | AD | BB | 1300 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 | CB | 600 | 0 |  |  |  |  |  | AB1234 | 2023 | BA |  | 5000 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 | DC | 1800 | 300 |  |  |  |  |  | AB1234 | 2023 | BB |  | 700 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 | EB | 600 | 600 |  |  |  |  |  | AB1234 | 2023 | BC |  | 600 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 | Total |  |  |  |  |  |  |  | AB1234 | 2023 | BD |  | 50 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | CA |  | 100 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | CB |  | 500 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | CB | BA | 0 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | CC |  | 500 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DA |  | 50 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DB |  | 1900 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DC |  | 1600 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DC | EA | 2900 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DC | EB | 300 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DC | EC | 0 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | EA |  | 3500 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | EB |  | 500 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | EC |  | 30 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | AA |  | 1100 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | AA | BA | 0 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | AB |  | 510 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | AC |  | 60 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | AD |  | 2000 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | AD | BB | 1400 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | BA |  | 5100 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | BB |  | 800 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | BC |  | 700 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | BD |  | 60 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | CA |  | 110 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | CB |  | 550 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | CB | BA | 0 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | CC |  | 600 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DA |  | 60 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DB |  | 2000 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DC |  | 1700 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DC | EA | 3000 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DC | EB | 300 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | DC | EC | 0 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | EA |  | 3600 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | EB |  | 550 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2023 | EC |  | 40 | 2023-04-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AA |  | 1200 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AA | BA | 0 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AB |  | 520 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AC |  | 70 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AD |  | 2000 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AD | BB | 1400 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | BA |  | 5100 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | BB |  | 800 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | BC |  | 700 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | BD |  | 60 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | CA |  | 150 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | CB |  | 600 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | CB | BA | 0 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | CC |  | 650 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DA |  | 70 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DB |  | 2000 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DC |  | 1800 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DC | EA | 3100 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DC | EB | 300 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DC | EC | 0 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | EA |  | 3600 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | EB |  | 600 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | EC |  | 50 | 2023-06-01 00:00:00 | 2023-08-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AA |  | 1300 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AA | BA | 0 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AB |  | 550 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AC |  | 90 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AD |  | 2100 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | AD | BB | 1500 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | BA |  | 5150 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | BB |  | 900 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | BC |  | 750 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | BD |  | 70 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | CA |  | 200 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | CB |  | 750 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | CB | BA | 0 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | CC |  | 700 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DA |  | 80 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DB |  | 2100 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DC |  | 1900 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DC | EA | 3200 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DC | EB | 300 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | DC | EC | 0 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | EA |  | 3700 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | EB |  | 700 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  |  |  |  | AB1234 | 2024 | EC |  | 60 | 2023-09-01 00:00:00 | 9999-12-31 00:00:00