Spreadsheet: 866598d1713521974-xlookup-or-filter-matrix-result-expected-but-value-returned-sample-xlookup-function-v4-
Sheet: report

Report year | 2023 | (incl. full previous year)
Report month YTD | 5
Type | B
Code | ZY
Using the formula without extra criteria in teh first matrix (flt) |  |  |  |  |  |  |  |  | Using the formula with the extra criteria in the first matrix (flt). The LOOKUP formula doesn't change. |  |  |  |  |  |  |  |  | Expected Lookup/calc result after validating all criteria
Year | Month | S | D | S (corr) | D (corr) | corr (S) | [NAME] (D) |  | Year | Month | S | D | S (corr) | D (corr) | corr (S) | [NAME] (D) |  | Year | Month | S | D | S (corr) | D (corr) | corr (S) | [NAME] (D)
 | 1 | 118056347 | 474969 | 132262049.1016371 | 477318.7834986923 | 0.1203298464049296 | 0.00494723550103715 |  |  | 1 | 28835056 | 98395 | #[NAME]! | #[NAME]! | N/A | N/A |  | 2022 | 1 | 28835056 | 98395
2022 | 2 | 182426928 | 576039 | 204378332.2263632 | 578888.8005907807 | #N/A | #N/A |  | 2022 | 2 | 50076210 | 123967 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 2 | 50076210 | 123967
2022 | 3 | 259251344 | 745325 | 290447018.4037912 | 749012.2982998093 | #N/A | #N/A |  | 2022 | 3 | 75552508 | 167022 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 3 | 75552508 | 167022
2022 | 4 | 264604428 | 711593 | 296444238.179304 | 715113.4181518899 | #N/A | #N/A |  | 2022 | 4 | 77020578 | 156125 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 4 | 77020578 | 156125
2022 | 5 | 302365036 | 752497 | 338748574.3401007 | 756219.7798728226 | #N/A | #N/A |  | 2022 | 5 | 90204424 | 179148 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 5 | 90204424 | 179148
2022 | 6 | 312862842 | 705631 | 350509579.7236699 | 709121.922733831 | #N/A | #N/A |  | 2022 | 6 | 95374644 | 175896 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 6 | 95374644 | 175896
2022 | 7 | 264205556 | 577762 | 295997369.972809 | 580620.3246775487 | #N/A | #N/A |  | 2022 | 7 | 88124868 | 143386 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 7 | 88124868 | 143386
2022 | 8 | 262569618 | 598284 | 294164579.8045411 | 601243.8518445014 | #N/A | #N/A |  | 2022 | 8 | 87931370 | 155524 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 8 | 87931370 | 155524
2022 | 9 | 322286467 | 731979 | 361067148.072498 | 735600.2724948137 | #N/A | #N/A |  | 2022 | 9 | 109244015 | 192835 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 9 | 109244015 | 192835
2022 | 10 | 310267282 | 694154 | 347601696.3875344 | 697588.143311988 | #N/A | #N/A |  | 2022 | 10 | 104440076 | 190862 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 10 | 104440076 | 190862
2022 | 11 | 281657618 | 660610 | 315549435.9127186 | 663878.1932443375 | #N/A | #N/A |  | 2022 | 11 | 88927011 | 173369 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 11 | 88927011 | 173369
2022 | 12 | 232604780 | 531105 | 260594077.4504522 | 533732.5015107786 | #N/A | #N/A |  | 2022 | 12 | 66740682 | 124471 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2022 | 12 | 66740682 | 124471
2023 | 1 | 331520289 | 792643 | 371412074.4554875 | 796564.3915892488 | #N/A | #N/A |  | 2023 | 1 | 94190161 | 181724 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2023 | 1 | 94190161 | 181724
2023 | 2 | 340943572 | 780185 | 381969259.6515089 | 784044.7589293752 | #N/A | #N/A |  | 2023 | 2 | 97601916 | 178506 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2023 | 2 | 97601916 | 178506
2023 | 3 | 366074424 | 835858 | 410124103.212693 | 839993.1863714232 | #N/A | #N/A |  | 2023 | 3 | 111679544 | 204855 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2023 | 3 | 111679544 | 204855
2023 | 4 | 303910892 | 703672 | 340480442.9551449 | 707153.2310994853 | #N/A | #N/A |  | 2023 | 4 | 91493324 | 169242 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2023 | 4 | 91493324 | 169242
2023 | 5 | 334382545 | 786203 | 374618745.2803399 | 790092.5313926213 | #N/A | #N/A |  | 2023 | 5 | 101008940 | 192633 | #[NAME]! | #[NAME]! | #N/A | #N/A |  | 2023 | 5 | 101008940 | 192633