Spreadsheet: 737589d1624490208-excel-formula-values-for-xlookup-are-not-coming-through-consistently-values-for-xlookup-are-not-coming-through-consistently
Sheet: Table

 |  |  |  |  |  |  | Generated ACV (Months)
 |  |  |  |  |  |  |  | Sales Rep 1 | [NAME] | [NAME] 3 | [NAME] | Sales Rep 5 | Sales Rep 6 | Sales Rep 7 | Sales Rep 8 | Sales Rep 9 | Sales Rep 10 | Sales Rep 11 | Sales Rep 12 | Sales Rep 13 | [NAME] 14 | Sales Rep 15 | [NAME] 16 | [NAME] 17 | Team 1 | Team 2 | Team 3 | Team 4 | Group 1 | Group 2 | Region (All)
 |  |  |  |  |  |  | Sep | 1382400 | 1378080 | 0 | 172800 | 0 | 432000 | 833760 | 514080 | 1123200 | 626400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2933280 | 2903040 | 626400 | 0 | 6462720 | 0 | 6462720
 |  |  |  |  |  |  | Oct | 699840 | 8925120 | 306720 | 8640 | 0 | 0 | 807840 | 1166400 | 1019520 | 25920 | 151200 | 0 | 432000 | 0 | 0 | 0 | 0 | 9940320 | 2993760 | 177120 | 432000 | 13111200 | 432000 | 13543200
 |  |  |  |  |  |  | Nov | 336960 | 1451520 | 1326240 | 1874880 | 0 | 0 | 1105920 | 527040 | 2164320 | 488160 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4989600 | 3797280 | 488160 | 0 | 9275040 | 0 | 9275040
 |  |  |  |  |  |  | Dec | 371520 | 3996000 | 1209600 | 2700000 | 0 | 0 | 756000 | 1157760 | 1058400 | 112320 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8277120 | 2972160 | 112320 | 0 | 11361600 | 0 | 11361600
 |  |  |  |  |  |  | Jan | 492480 | 885600 | 1594080 | 3633120 | 0 | 0 | 1537920 | 894240 | 1231200 | 125280 | 263520 | 0 | 0 | 0 | 0 | 0 | 0 | 6605280 | 3663360 | 388800 | 0 | 10657440 | 0 | 10657440
 |  |  |  |  |  |  | Feb | 2682720 | 384480 | 660960 | 501120 | 0 | 0 | 1045440 | 669600 | 1300320 | 794880 | 17280 | 0 | 0 | 0 | 0 | 0 | 0 | 4229280 | 3015360 | 812160 | 0 | 8056800 | 0 | 8056800
 |  |  |  |  |  |  | Mar | 60480 | 1105920 | 13262400 | 9560160 | 0 | 0 | 1006560 | 846720 | 864000 | 440640 | 43200 | 0 | 0 | 0 | 0 | 0 | 0 | 23988960 | 2717280 | 483840 | 0 | 27190080 | 0 | 27190080
 |  |  |  |  |  |  | Apr | 120960 | 1049760 | 1555200 | 13003200 | 432000 | 129600 | 660960 | 799200 | 803520 | 267840 | 12960 | 0 | 0 | 0 | 0 | 0 | 0 | 15729120 | 2825280 | 280800 | 0 | 18835200 | 0 | 18835200
 |  |  |  |  |  |  | May | 4656960 | 8488800 | 6125760 | 371520 | 38880 | 0 | 69120 | 1987200 | 241920 | 2704320 | 38880 | 2505600 | 0 | 864000 | 432000 | 12096000 | 0 | 19643040 | 2337120 | 2743200 | 15897600 | 24723360 | 15897600 | 40620960
 |  |  |  |  |  |  | Jun | 211680 | 19310400 | 51840 | 1503360 | 0 | 0 | 198720 | 146880 | 557280 | 660960 | 77760 | 0 | 0 | 0 | 0 | 0 | 228960 | 21077280 | 902880 | 738720 | 228960 | 22718880 | 228960 | 22947840
 |  |  |  |  |  |  | Jul | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Aug | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Sep | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Oct | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Nov | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Dec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Selection Sales
 |  |  |  |  |  |  |  |  |  | Team 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target ACV 2021
 |  |  |  |  |  |  |  |  |  | Selection Year | Selection Month | Month Number |  |  |  |  |  |  |  |  |  |  |  | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  |  |  |  |  |  | 2020 | Nov |  |  |  |  |  |  |  |  |  |  |  | Team 1 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800 | 1900800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 2 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200 | 1555200
 |  |  |  |  |  |  |  |  | Month Number | Month | ACV | Target (x3 Quote) | Above Target | Below Target |  |  |  |  |  |  |  |  | Team 3 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400 | 950400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team 4 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group 1 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400 | 4406400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group 2 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Region (All) | 2616640 | 2616640 | 2616640 | 2037680 | 2643657.696 | 2904484.608 | 3155044.464 | 2873901.888 | 3155044.464 | 3408990.264 | 3104146.089 | 3659550.12 | 3659550.12 | 3913495.92 | 3561248.52 | 2511278.208
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 1 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 3 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 5 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 6 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 7 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 8 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800 | 388800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 9 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 10 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200 | 475200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 11 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 12 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 13 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 14 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales Rep 15 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 16 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 17 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000 | 1950000