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

 |  | Month | Model | Amount | Category
 |  |  |  |  | 1
 |  | -125317.1761773238 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | YTD |  |  | YTD
 |  | 500 | -174.29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | -174.29
 |  | 750 | -2262.167420000004 | -205.6622 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 750 | -2467.829620000004
 |  | 900 | 0 | -2669.357555600005 | -1975.324591144004 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900 | -4644.682146744009
 |  | AB | -661.97716 | -781.1330488 | -578.038456112 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | AB | -2021.148664912
 |  | AD | -53.8898 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | AD | -53.8898
 |  | AG | 0 | -63.58996399999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | AG | -63.58996399999999
 |  | AL | -1523.33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | AL | -1523.33
 |  | AN | 0 | -1797.5294 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | AN | -1797.5294
 |  | BX | -4056.255 | -4786.3809 | -3541.921866 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BX | -12384.557766
 |  | BZ | -3228.96 | -3810.1728 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BZ | -7039.132799999999
 |  | CA | -1841.355 | -2172.7989 | -1607.871186 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CA | -5622.025086
 |  | CB | -402.3125 | -474.72875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | CB | -877.04125
 |  | DE | 0 | -1471.4364 | -1088.862936 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DE | -2560.299336
 |  | DF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DF | 0
 |  | DS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DS | 0
 |  | DV | 0 | -4460.2879 | -3300.613046 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DV | -7760.900946
 |  | DX | 0 | -3484.0798 | -2578.219052 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DX | -6062.298852
 |  | FA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FA | 0
 |  | GL | -2868.781915198807 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | GL | -2868.781915198807
 |  | GM | -221.0269653693443 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | GM | -221.0269653693443
 |  | LA | 0 | 0 | -4488.83374256 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LA | -4488.83374256
 |  | LJ | 0 | 0 | -3506.37791072 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LJ | -3506.37791072
 |  | MF | -755.3130685052638 | -891.2694208362112 | -659.5393714187963 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MF | -2306.121860760271
 |  | MR | -9278.193647035247 | -10948.26850350159 | -8101.718692591177 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | MR | -28328.18084312802
 |  | OA | -328.2282893398016 | -387.3093814209659 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | OA | -715.5376707607675
 |  | OB | -123.2664119982595 | -145.4543661579462 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | OB | -268.7207781562057
 |  | OR | -154.8486199890987 | -182.7213715871364 | -135.213814974481 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | OR | -472.7838065507161
 |  | RA | 0 | -565.1764208362113 | -418.2305514187963 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | RA | -983.4069722550075
 |  | RF | 0 | -10622.17550350159 | -7860.409872591177 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | RF | -18482.58537609277
 |  | TM | 0 | -61.21638142096588 | -45.30012225151475 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | TM | -106.5165036724806
 |  | ZB | 0 | 0 | -3591.066994048001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ZB | -3591.066994048001
 |  | ZP | -271.5391654515289 | -320.4162152328041 | -2805.102328576 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ZP | -3397.057709260333
 |  | ZQ | 0 | 0 | -527.6314971350371 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ZQ | -527.6314971350371
 |  | ZZZ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ZZZ | 0