Spreadsheet: 584525d1533235895-2d-index-match-match-and-error-trapping-index-match-match-accounting-for-blanks
Sheet: Data

 | 2016 sales by customer and month
 | Customer | January | February | March | April | May | June | July | August | September | October | November | December
 | [NAME]'s Sweets | 21137.5 | 78837.5 | 44800 | 50400 | 76825 | 62150 | 68350 | 98000 | 46000 | 101500 | 88137.5 | 85600
 | Boston Sweets | 35075 | 23640 | 0 | 9275 | 17525 | 33950 | 14300 | 18575 | 30150 | 17847.5 | 35750 | 14350
 | Brooks Candies | 117250 | 62400 | 69500 | 26200 | 180000 | 249375 | 82800 | 82500 | 72500 | 120750 | 179200 | 316000
 | [NAME] | 1000 | 13855 | 34275 | 21662.5 | 9040 | 34125 | 22225 | 12975 | 32400 | 36175 | 21620 | 34725
 | [NAME] | 34125 | 49200 | 23625 | 31950 | 24900 | 35000 | 22500 | 24250 | 36250 | 45500 | 77700 | 78500
 | Candy 'n Things | 59080 | 140670 | 74400 | 101712.5 | 50400 | 136087.5 | 72010 | 73400 | 109500 | 66075 | 207525 | 7200 |  |  |  | January | April | July | October
 | Candyland | 21112.5 | 42845 | 45300 | 9925 | 32775 | 27512.5 | 10000 | 63750 | 14850 | 29480 | 16197.5 | 25575 |  |  | Brooks Candies
 | [NAME]'s | 35392.5 | 6375 | 30187.5 | 21225 | 38225 | 45725 | 20025 | 31387.5 | 39637.5 | 43622.5 | 18862.5 | 33225 |  |  | [NAME]
 | F.B.D. Confections | 20437.5 | 10885 | 16925 | 10700 | 18470 | 45850 | 19850 | 16300 | 10550 | 25275 | 2850 | 42700 |  |  | Candyland
 | [NAME]'s Wholesale | 98750 | 59012.5 | 57375 | 31500 | 15650 | 24565 | 116637.5 | 77625 | 38250 | 70250 | 97925 | 398925 |  |  | [NAME]'s Wholesale
 | Heavenly, LLC | 5075 | 4072.5 | 2367.5 | 1725 | 1382.5 | 5475 | 4475 | 7050 | 3565 | 5072.5 | 4837.5 | 2425 |  |  | [NAME] Snack Shop
 | [NAME] Snack Shop | 53550 | 70350 | 97500 | 54600 | 73200 | 81900 | 69900 | 52500 | 142750 | 155750 | 82600 | 94250
 | King [NAME] | 17850 | 27625 | 7912.5 | 12775 | 8147.5 | 18475 | 34200 | 20850 | 27187.5 | 48987.5 | 27600 | 63150 |  |  | I want it to return as below
 | Lickety Split | 35775 | 0 | 25600 | 25000 | 33600 | 60200 | 32150 | 49400 | 26250 | 46625 | 17442.5 | 80000 |  |  | but including the iferror and if index match = 0 as above
 | Miel | 18905 | 54620 | 20250 | 76762.5 | 159975 | 212620 | 104225 | 120825 | 24750 | 59487.5 | 184685 | 42750 |  |  |  | January | April | July | October
 | Philadelphia Treats | 54287.5 | 35050 | 39200 | 61850 | 23412.5 | 123075 | 57600 | 100000 | 56100 | 37940 | 55675 | 67600 |  |  | Brooks Candies
 | Pop [NAME] | 49875 | 42300 | 8500 | 37350 | 36750 | 84525 | 83100 | 39375 | 38125 | 54437.5 | 40700 | 101500 |  |  | [NAME]
 | R.B. Dunham's | 22050 | 30050 | 16500 | 9725 | 42310 | 42425 | 6250 | 39187.5 | 25275 | 40982.5 | 29525 | 67950 |  |  | Candyland
 | Rapture, Inc. | 139825 | 15350 | 51000 | 106575 | 82560 | 93025 | 82750 | 43100 | 51900 | 117660 | 51200 | 42200 |  |  | [NAME]'s Wholesale
 | [NAME]'s | 30380 | 45250 | 40600 | 10090 | 39675 | 38225 | 53700 | 51000 | 65700 | 29250 | 33600 | 44000 |  |  | [NAME] Snack Shop
 | SF Candy Shack | 115325 | 83700 | 58875 | 47500 | 22200 | 97300 | 102000 | 157250 | 39750 | 85050 | 174400 | 71750
 | Snack Hut | 166600 | 143100 | 22250 | 91600 | 152100 | 97300 | 128700 | 57750 | 114625 | 81550 | 256800 | 132500
 | [NAME] | 68705 | 23312.5 | 57925 | 24330 | 48460 | 26210 | 22785 | 71575 | 56875 | 119700 | 56000 | 31675
 | Sugar, Inc. | 8812.5 | 9080 | 7475 | 11762.5 | 10585 | 13490 | 15025 | 8400 | 9900 | 12625 | 7410 | 38887.5
 | [NAME] | 54525 | 102325 | 25312.5 | 29880 | 97200 | 88512.5 | 88375 | 23400 | 20250 | 125287.5 | 77050 | 67950
 | Sweets 'R Us | 61475 | 55200 | 61000 | 34220 | 65932.5 | 161612.5 | 57600 | 57200 | 30200 | 14000 | 3200 | 104400
 | Tastebud Paradise | 79975 | 35250 | 78250 | 57600 | 117000 | 64750 | 16500 | 126500 | 78250 | 66150 | 285200 | 100000
 | The Kandy Korn | 32637.5 | 32700 | 44250 | 31000 | 53250 | 74025 | 26550 | 25500 | 44375 | 34575 | 64700 | 40500
 | The Sweet Emporium | 20587.5 | 14577.5 | 1125 | 18175 | 31637.5 | 31825 | 38370 | 4500 | 35925 | 19735 | 83400 | 53025
 | Wonka's World | 96637.5 | 69120 | 23200 | 11200 | 85330 | 112790 | 111400 | 114400 | 83000 | 106900 | 158725 | 166000