Spreadsheet: 45697d1244530814-nesting-vlookup-in-if-vice-versa-and-pivot-table-modelcategoryytd
Sheet: sData

Month | Model | Amount | Category
Jan | 500 | -174.29 | 1
Jan | 750 | -2262.167420000004 | 1
Jan | AB | -661.97716 | 1
Jan | AD | -53.8898 | 1
Jan | AL | -1523.33 | 1
Jan | BX | -4056.255 | 1
Jan | BZ | -3228.96 | 1
Jan | CA | -1841.355 | 1
Jan | CB | -402.3125 | 1
Jan | GL | -2868.781915198807 | 1
Jan | GM | -221.0269653693443 | 1
Jan | MF | -755.3130685052638 | 1
Jan | MR | -9278.193647035247 | 1
Jan | OA | -328.2282893398016 | 1
Jan | OB | -123.2664119982595 | 1
Jan | OR | -154.8486199890987 | 1
Jan | ZP | -271.5391654515289 | 1
Jan | 500 | 245.7489 | 2
Jan | 750 | 3189.656062200006 | 2
Jan | AB | 933.3877956 | 2
Jan | AD | 75.984618 | 2
Jan | AL | 2147.8953 | 2
Jan | BX | 5719.31955 | 2
Jan | BZ | 4552.8336 | 2
Jan | CA | 2596.31055 | 2
Jan | CB | 567.260625 | 2
Jan | DF | 1143.86391 | 2
Jan | DS | 910.56672 | 2
Jan | FA | 519.2621099999999 | 2
Jan | GL | 4044.982500430317 | 2
Jan | GM | 311.6480211707755 | 2
Jan | MF | 1064.991426592422 | 2
Jan | MR | 13082.2530423197 | 2
Jan | OA | 462.8018879691202 | 2
Jan | OB | 173.8056409175458 | 2
Jan | OR | 218.3365541846291 | 2
Jan | ZP | 382.8702232866557 | 2
Feb | 750 | -205.6622 | 1
Feb | 900 | -2669.357555600005 | 1
Feb | AB | -781.1330488 | 1
Feb | AG | -63.58996399999999 | 1
Feb | AN | -1797.5294 | 1
Feb | BX | -4786.3809 | 1
Feb | BZ | -3810.1728 | 1
Feb | CA | -2172.7989 | 1
Feb | CB | -474.72875 | 1
Feb | DE | -1471.4364 | 1
Feb | DV | -4460.2879 | 1
Feb | DX | -3484.0798 | 1
Feb | MF | -891.2694208362112 | 1
Feb | MR | -10948.26850350159 | 1
Feb | OA | -387.3093814209659 | 1
Feb | OB | -145.4543661579462 | 1
Feb | OR | -182.7213715871364 | 1
Feb | RA | -565.1764208362113 | 1
Feb | RF | -10622.17550350159 | 1
Feb | TM | -61.21638142096588 | 1
Feb | ZP | -320.4162152328041 | 1
Feb | 750 | 355.63107624 | 2
Feb | 900 | 4615.853085143529 | 2
Feb | AB | 1350.73526798496 | 2
Feb | AG | 109.9597657488 | 2
Feb | AN | 3108.28783848 | 2
Feb | BX | 8276.60985228 | 2
Feb | BZ | 6588.55080576 | 2
Feb | CA | 3757.20385788 | 2
Feb | CB | 820.9009545000001 | 2
Feb | MF | 1541.183082509977 | 2
Feb | MR | 18931.74589625495 | 2
Feb | OA | 669.7353823531344 | 2
Feb | OB | 251.5196899603205 | 2
Feb | OR | 315.9617957484763 | 2
Feb | RA | 977.3030669099766 | 2
Feb | RF | 18367.86588065495 | 2
Feb | TM | 105.8553667531342 | 2
Feb | ZP | 554.0637193805649 | 2
Mar | 900 | -1975.324591144004 | 1
Mar | AB | -578.038456112 | 1
Mar | BX | -3541.921866 | 1
Mar | CA | -1607.871186 | 1
Mar | DE | -1088.862936 | 1
Mar | DV | -3300.613046 | 1
Mar | DX | -2578.219052 | 1
Mar | LA | -4488.83374256 | 1
Mar | LJ | -3506.37791072 | 1
Mar | MF | -659.5393714187963 | 1
Mar | MR | -8101.718692591177 | 1
Mar | OR | -135.213814974481 | 1
Mar | RA | -418.2305514187963 | 1
Mar | RF | -7860.409872591177 | 1
Mar | TM | -45.30012225151475 | 1
Mar | ZB | -3591.066994048001 | 1
Mar | ZP | -2805.102328576 | 1
Mar | ZQ | -527.6314971350371 | 1
Mar | 750 | 219.89402424 | 2
Mar | 900 | 2854.077098447526 | 2
Mar | AB | 835.1874557769601 | 2
Mar | AG | 67.99038950879999 | 2
Mar | AN | 1921.91843448 | 2
Mar | BX | 5117.59845828 | 2
Mar | BZ | 4073.83675776 | 2
Mar | CA | 2323.15658388 | 2
Mar | CB | 507.5799795000001 | 2
Mar | LA | 2456.4472599744 | 2
Mar | MF | 952.9452647580772 | 2
Mar | MR | 11705.8886839439 | 2
Mar | OA | 414.1111906152968 | 2
Mar | OB | 155.5198082960761 | 2
Mar | OR | 195.3656905009663 | 2
Mar | RA | 604.2866291580772 | 2
Mar | RF | 11357.2300483439 | 2
Mar | TM | 65.45255501529672 | 2
Mar | ZB | 2892.4240980096 | 2
Mar | ZP | 1649.4411745548 | 2
Apr | ZZZ | 0 | 0
Mar | ZQ | 360.381785445 | 2