Spreadsheet: 866653d1713542051-xlookup-or-filter-matrix-result-expected-but-value-returned-sample-xlookup-function-v4-hd
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) |  |  |  |  |  |  |  |  | This formula returns the expected results |  |  |  |  |  |  |  |  | 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 | 33140796.99548686 | 98680.74741777855 |  |  |  | 2022 | 1 | 28835056 | 98395
2022 | 2 | 182426928 | 576039 | 204378332.2263632 | 578888.8005907807 | #N/A | #N/A |  | 2022 | 2 | 50076210 | 123967 | 56831624.35261022 | 124297.7722894702 |  |  |  | 2022 | 2 | 50076210 | 123967
2022 | 3 | 259251344 | 745325 | 290447018.4037912 | 749012.2982998093 | #N/A | #N/A |  | 2022 | 3 | 75552508 | 167022 | 85345805.75411762 | 167672.2433856004 |  |  |  | 2022 | 3 | 75552508 | 167022
2022 | 4 | 264604428 | 711593 | 296444238.179304 | 715113.4181518899 | #N/A | #N/A |  | 2022 | 4 | 77020578 | 156125 | 86773175.06430684 | 156481.9167453926 |  |  |  | 2022 | 4 | 77020578 | 156125
2022 | 5 | 302365036 | 752497 | 338748574.3401007 | 756219.7798728226 | #N/A | #N/A |  | 2022 | 5 | 90204424 | 179148 | 101058708.4849651 | 180034.2873455398 |  |  |  | 2022 | 5 | 90204424 | 179148
2022 | 6 | 312862842 | 705631 | 350509579.7236699 | 709121.922733831 | #N/A | #N/A |  | 2022 | 6 | 95374644 | 175896 | 105604481.1942278 | 176439.8501949631 |  |  |  | 2022 | 6 | 95374644 | 175896
2022 | 7 | 264205556 | 577762 | 295997369.972809 | 580620.3246775487 | #N/A | #N/A |  | 2022 | 7 | 88124868 | 143386 | 96808433.15751581 | 144030.3101292833 |  |  |  | 2022 | 7 | 88124868 | 143386
2022 | 8 | 262569618 | 598284 | 294164579.8045411 | 601243.8518445014 | #N/A | #N/A |  | 2022 | 8 | 87931370 | 155524 | 98111951.02591267 | 156965.8137017552 |  |  |  | 2022 | 8 | 87931370 | 155524
2022 | 9 | 322286467 | 731979 | 361067148.072498 | 735600.2724948137 | #N/A | #N/A |  | 2022 | 9 | 109244015 | 192835 | 121295093.4683724 | 193492.7997725863 |  |  |  | 2022 | 9 | 109244015 | 192835
2022 | 10 | 310267282 | 694154 | 347601696.3875344 | 697588.143311988 | #N/A | #N/A |  | 2022 | 10 | 104440076 | 190862 | 116025722.5892348 | 191899.7659677505 |  |  |  | 2022 | 10 | 104440076 | 190862
2022 | 11 | 281657618 | 660610 | 315549435.9127186 | 663878.1932443375 | #N/A | #N/A |  | 2022 | 11 | 88927011 | 173369 | 99420163.12004887 | 174257.2602911735 |  |  |  | 2022 | 11 | 88927011 | 173369
2022 | 12 | 232604780 | 531105 | 260594077.4504522 | 533732.5015107786 | #N/A | #N/A |  | 2022 | 12 | 66740682 | 124471 | 74538152.61372688 | 124920.9536886895 |  |  |  | 2022 | 12 | 66740682 | 124471
2023 | 1 | 331520289 | 792643 | 371412074.4554875 | 796564.3915892488 | #N/A | #N/A |  | 2023 | 1 | 94190161 | 181724 | 106092627.5317323 | 182897.339011574 |  |  |  | 2023 | 1 | 94190161 | 181724
2023 | 2 | 340943572 | 780185 | 381969259.6515089 | 784044.7589293752 | #N/A | #N/A |  | 2023 | 2 | 97601916 | 178506 | 109198470.3649255 | 179209.408369756 |  |  |  | 2023 | 2 | 97601916 | 178506
2023 | 3 | 366074424 | 835858 | 410124103.212693 | 839993.1863714232 | #N/A | #N/A |  | 2023 | 3 | 111679544 | 204855 | 124630941.7124323 | 205872.8538837075 |  |  |  | 2023 | 3 | 111679544 | 204855
2023 | 4 | 303910892 | 703672 | 340480442.9551449 | 707153.2310994853 | #N/A | #N/A |  | 2023 | 4 | 91493324 | 169242 | 102636501.0600175 | 170075.8664736009 |  |  |  | 2023 | 4 | 91493324 | 169242
2023 | 5 | 334382545 | 786203 | 374618745.2803399 | 790092.5313926213 | #N/A | #N/A |  | 2023 | 5 | 101008940 | 192633 | 113115102.9407158 | 193916.8737090468 |  |  |  | 2023 | 5 | 101008940 | 192633