Multi-conditional Index/Match Function

L

Laviah01

New Member
Joined
May 8, 2019
Messages
3
Hello,

Hoping that someone could assist!

I have a workbook where I needed to use the index/match function to source the data. While I was able to successfully complete the formula, I need that the formula also takes into consideration the dates.

So for example, if the source data has excluded February 7th and 8th data, but my standard file has columns to represent February 7th and 8th, I just want to report zero for those periods. I initially tried to also incorporate the "IF" function with the Index/Match function but was unsuccessful, I need the formula to account for any missing data points, any suggestions?

See sample formula as follows: =INDEX('Source Data'!B4:B22,MATCH("Pear 1",'Source Data'!$A$4:$A$22,0))

Source Data
Excel 2016 (Windows) 32 bit
ABCDEFGHIJKLMNOPQ
Pear 1
Pear 2
Pear 3
Pear 4
Pear 5
Pear 6
Pear 7
Pear 8
Pear 9
Pear 10
Pear 11
Pear 12
Pear 13
Pear 14
Pear 15
Pear 16
Pear 17
Pear 18
Pear 19
The source data is missing certain periods, but the standard sheet still has those missing dates…February 7th and 8th is missing from the source data, but these will still be in the standard sheet.

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: center"]1-Feb-19[/TD]
[TD="align: center"]4-Feb-19[/TD]
[TD="align: center"]5-Feb-19[/TD]
[TD="bgcolor: #FFFF00, align: center"]6-Feb-19[/TD]
[TD="bgcolor: #FFFF00, align: center"]11-Feb-19[/TD]
[TD="align: center"]12-Feb-19[/TD]
[TD="align: center"]13-Feb-19[/TD]
[TD="align: center"]14-Feb-19[/TD]
[TD="bgcolor: #FFFF00, align: center"]15-Feb-19[/TD]
[TD="bgcolor: #FFFF00, align: center"]19-Feb-19[/TD]
[TD="align: center"]20-Feb-19[/TD]
[TD="align: center"]22-Feb-19[/TD]
[TD="align: center"]25-Feb-19[/TD]
[TD="align: center"]26-Feb-19[/TD]
[TD="align: center"]27-Feb-19[/TD]
[TD="align: center"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"] 770.0[/TD]
[TD="align: right"] 1,670.0[/TD]
[TD="align: right"] 880.0[/TD]
[TD="align: right"] 1,100.0[/TD]
[TD="align: right"] 760.0[/TD]
[TD="align: right"] 900.0[/TD]
[TD="align: right"] 1,080.0[/TD]
[TD="align: right"] 1,070.0[/TD]
[TD="align: right"] 810.0[/TD]
[TD="align: right"] 880.0[/TD]
[TD="align: right"] 310.0[/TD]
[TD="align: right"] 760.0[/TD]
[TD="align: right"] 1,100.0[/TD]
[TD="align: right"] 900.0[/TD]
[TD="align: right"] 730.0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"] 90.0[/TD]
[TD="align: right"] 60.0[/TD]
[TD="align: right"] 40.0[/TD]
[TD="align: right"] 40.0[/TD]
[TD="align: right"] 720.0[/TD]
[TD="align: right"] 30.0[/TD]
[TD="align: right"] 20.0[/TD]
[TD="align: right"] 20.0[/TD]
[TD="align: right"] 60.0[/TD]
[TD="align: right"] 470.0[/TD]
[TD="align: right"] 1,430.0[/TD]
[TD="align: right"] 720.0[/TD]
[TD="align: right"] 40.0[/TD]
[TD="align: right"] 40.0[/TD]
[TD="align: right"] 30.0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"] 10.0[/TD]
[TD="align: right"] 70.0[/TD]
[TD="align: right"] 40.0[/TD]
[TD="align: right"] 10.0[/TD]
[TD="align: right"] 20.0[/TD]
[TD="align: right"] 60.0[/TD]
[TD="align: right"] 50.0[/TD]
[TD="align: right"] 70.0[/TD]
[TD="align: right"] 80.0[/TD]
[TD="align: right"] 10.0[/TD]
[TD="align: right"] 20.0[/TD]
[TD="align: right"] 20.0[/TD]
[TD="align: right"] 10.0[/TD]
[TD="align: right"] 10.0[/TD]
[TD="align: right"] 80.0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"] -[/TD]
[TD="align: right"] 4,240.0[/TD]
[TD="align: right"] 940.0[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,150.0[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 260.0[/TD]
[TD="align: right"] 1,110.0[/TD]
[TD="align: right"] 950.0[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,800.0[/TD]
[TD="align: right"] 1,150.0[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,850.0[/TD]
[TD="align: right"] 1,740.0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"] -[/TD]
[TD="align: right"] 530.0[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 10.0[/TD]
[TD="align: right"] 150.0[/TD]
[TD="align: right"] 560.0[/TD]
[TD="align: right"] 110.0[/TD]
[TD="align: right"] 6,770.0[/TD]
[TD="align: right"] 150.0[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 170.0[/TD]
[TD="align: right"] 150.0[/TD]
[TD="align: right"] 10.0[/TD]
[TD="align: right"] 1,810.0[/TD]
[TD="align: right"] 240.0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"] 654.5[/TD]
[TD="align: right"] 1,419.5[/TD]
[TD="align: right"] 748.0[/TD]
[TD="align: right"] 935.0[/TD]
[TD="align: right"] 646.0[/TD]
[TD="align: right"] 765.0[/TD]
[TD="align: right"] 918.0[/TD]
[TD="align: right"] 909.5[/TD]
[TD="align: right"] 688.5[/TD]
[TD="align: right"] 748.0[/TD]
[TD="align: right"] 263.5[/TD]
[TD="align: right"] 646.0[/TD]
[TD="align: right"] 935.0[/TD]
[TD="align: right"] 765.0[/TD]
[TD="align: right"] 620.5[/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"] 76.5[/TD]
[TD="align: right"] 51.0[/TD]
[TD="align: right"] 34.0[/TD]
[TD="align: right"] 34.0[/TD]
[TD="align: right"] 612.0[/TD]
[TD="align: right"] 25.5[/TD]
[TD="align: right"] 17.0[/TD]
[TD="align: right"] 17.0[/TD]
[TD="align: right"] 51.0[/TD]
[TD="align: right"] 399.5[/TD]
[TD="align: right"] 1,215.5[/TD]
[TD="align: right"] 612.0[/TD]
[TD="align: right"] 34.0[/TD]
[TD="align: right"] 34.0[/TD]
[TD="align: right"] 25.5[/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"] 8.5[/TD]
[TD="align: right"] 59.5[/TD]
[TD="align: right"] 34.0[/TD]
[TD="align: right"] 8.5[/TD]
[TD="align: right"] 17.0[/TD]
[TD="align: right"] 51.0[/TD]
[TD="align: right"] 42.5[/TD]
[TD="align: right"] 59.5[/TD]
[TD="align: right"] 68.0[/TD]
[TD="align: right"] 8.5[/TD]
[TD="align: right"] 17.0[/TD]
[TD="align: right"] 17.0[/TD]
[TD="align: right"] 8.5[/TD]
[TD="align: right"] 8.5[/TD]
[TD="align: right"] 68.0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: right"] -[/TD]
[TD="align: right"] 3,604.0[/TD]
[TD="align: right"] 799.0[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 977.5[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 221.0[/TD]
[TD="align: right"] 943.5[/TD]
[TD="align: right"] 807.5[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,530.0[/TD]
[TD="align: right"] 977.5[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,572.5[/TD]
[TD="align: right"] 1,479.0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"] -[/TD]
[TD="align: right"] 450.5[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 8.5[/TD]
[TD="align: right"] 127.5[/TD]
[TD="align: right"] 476.0[/TD]
[TD="align: right"] 93.5[/TD]
[TD="align: right"] 5,754.5[/TD]
[TD="align: right"] 127.5[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 144.5[/TD]
[TD="align: right"] 127.5[/TD]
[TD="align: right"] 8.5[/TD]
[TD="align: right"] 1,538.5[/TD]
[TD="align: right"] 204.0[/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"] 556.3[/TD]
[TD="align: right"] 1,206.6[/TD]
[TD="align: right"] 635.8[/TD]
[TD="align: right"] 794.8[/TD]
[TD="align: right"] 549.1[/TD]
[TD="align: right"] 650.3[/TD]
[TD="align: right"] 780.3[/TD]
[TD="align: right"] 773.1[/TD]
[TD="align: right"] 585.2[/TD]
[TD="align: right"] 635.8[/TD]
[TD="align: right"] 224.0[/TD]
[TD="align: right"] 549.1[/TD]
[TD="align: right"] 794.8[/TD]
[TD="align: right"] 650.3[/TD]
[TD="align: right"] 527.4[/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"] 65.0[/TD]
[TD="align: right"] 43.4[/TD]
[TD="align: right"] 28.9[/TD]
[TD="align: right"] 28.9[/TD]
[TD="align: right"] 520.2[/TD]
[TD="align: right"] 21.7[/TD]
[TD="align: right"] 14.5[/TD]
[TD="align: right"] 14.5[/TD]
[TD="align: right"] 43.4[/TD]
[TD="align: right"] 339.6[/TD]
[TD="align: right"] 1,033.2[/TD]
[TD="align: right"] 520.2[/TD]
[TD="align: right"] 28.9[/TD]
[TD="align: right"] 28.9[/TD]
[TD="align: right"] 21.7[/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"] 7.2[/TD]
[TD="align: right"] 50.6[/TD]
[TD="align: right"] 28.9[/TD]
[TD="align: right"] 7.2[/TD]
[TD="align: right"] 14.5[/TD]
[TD="align: right"] 43.4[/TD]
[TD="align: right"] 36.1[/TD]
[TD="align: right"] 50.6[/TD]
[TD="align: right"] 57.8[/TD]
[TD="align: right"] 7.2[/TD]
[TD="align: right"] 14.5[/TD]
[TD="align: right"] 14.5[/TD]
[TD="align: right"] 7.2[/TD]
[TD="align: right"] 7.2[/TD]
[TD="align: right"] 57.8[/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"] -[/TD]
[TD="align: right"] 3,063.4[/TD]
[TD="align: right"] 679.2[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 830.9[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 187.9[/TD]
[TD="align: right"] 802.0[/TD]
[TD="align: right"] 686.4[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,300.5[/TD]
[TD="align: right"] 830.9[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,336.6[/TD]
[TD="align: right"] 1,257.2[/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"] -[/TD]
[TD="align: right"] 382.9[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 7.2[/TD]
[TD="align: right"] 108.4[/TD]
[TD="align: right"] 404.6[/TD]
[TD="align: right"] 79.5[/TD]
[TD="align: right"] 4,891.3[/TD]
[TD="align: right"] 108.4[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 122.8[/TD]
[TD="align: right"] 108.4[/TD]
[TD="align: right"] 7.2[/TD]
[TD="align: right"] 1,307.7[/TD]
[TD="align: right"] 173.4[/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"] 472.9[/TD]
[TD="align: right"] 1,025.6[/TD]
[TD="align: right"] 540.4[/TD]
[TD="align: right"] 675.5[/TD]
[TD="align: right"] 466.7[/TD]
[TD="align: right"] 552.7[/TD]
[TD="align: right"] 663.3[/TD]
[TD="align: right"] 657.1[/TD]
[TD="align: right"] 497.4[/TD]
[TD="align: right"] 540.4[/TD]
[TD="align: right"] 190.4[/TD]
[TD="align: right"] 466.7[/TD]
[TD="align: right"] 675.5[/TD]
[TD="align: right"] 552.7[/TD]
[TD="align: right"] 448.3[/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"] 55.3[/TD]
[TD="align: right"] 36.8[/TD]
[TD="align: right"] 24.6[/TD]
[TD="align: right"] 24.6[/TD]
[TD="align: right"] 442.2[/TD]
[TD="align: right"] 18.4[/TD]
[TD="align: right"] 12.3[/TD]
[TD="align: right"] 12.3[/TD]
[TD="align: right"] 36.8[/TD]
[TD="align: right"] 288.6[/TD]
[TD="align: right"] 878.2[/TD]
[TD="align: right"] 442.2[/TD]
[TD="align: right"] 24.6[/TD]
[TD="align: right"] 24.6[/TD]
[TD="align: right"] 18.4[/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"] 6.1[/TD]
[TD="align: right"] 43.0[/TD]
[TD="align: right"] 24.6[/TD]
[TD="align: right"] 6.1[/TD]
[TD="align: right"] 12.3[/TD]
[TD="align: right"] 36.8[/TD]
[TD="align: right"] 30.7[/TD]
[TD="align: right"] 43.0[/TD]
[TD="align: right"] 49.1[/TD]
[TD="align: right"] 6.1[/TD]
[TD="align: right"] 12.3[/TD]
[TD="align: right"] 12.3[/TD]
[TD="align: right"] 6.1[/TD]
[TD="align: right"] 6.1[/TD]
[TD="align: right"] 49.1[/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"] -[/TD]
[TD="align: right"] 2,603.9[/TD]
[TD="align: right"] 577.3[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 706.2[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 159.7[/TD]
[TD="align: right"] 681.7[/TD]
[TD="align: right"] 583.4[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,105.4[/TD]
[TD="align: right"] 706.2[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,136.1[/TD]
[TD="align: right"] 1,068.6[/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Source Data​





Standard Template
Excel 2016 (Windows) 32 bit
ABCDEFGHIJKLMNOPQRSTUV
Total
Technically the 7th and the 8th are missing from the source data, I need the formula to report zeros should any data point be missing from the source file.
Pear 1
Pear 3
Pear 11
Pear 14
Pear 2
Pear 7
Pear 10

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: center"]1-Feb-19[/TD]
[TD="align: center"]4-Feb-19[/TD]
[TD="align: center"]5-Feb-19[/TD]
[TD="align: center"]6-Feb-19[/TD]
[TD="bgcolor: #FFFF00, align: center"]7-Feb-19[/TD]
[TD="bgcolor: #FFFF00, align: center"]8-Feb-19[/TD]
[TD="align: center"]11-Feb-19[/TD]
[TD="align: center"]12-Feb-19[/TD]
[TD="align: center"]13-Feb-19[/TD]
[TD="align: center"]14-Feb-19[/TD]
[TD="align: center"]15-Feb-19[/TD]
[TD="align: center"]18-Feb-19[/TD]
[TD="align: center"]19-Feb-19[/TD]
[TD="align: center"]20-Feb-19[/TD]
[TD="align: center"]21-Feb-19[/TD]
[TD="align: center"]22-Feb-19[/TD]
[TD="align: center"]25-Feb-19[/TD]
[TD="align: center"]26-Feb-19[/TD]
[TD="align: center"]27-Feb-19[/TD]
[TD="align: center"]28-Feb-19[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: #D9D9D9"]Section 1[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1336.33[/TD]
[TD="bgcolor: #D9D9D9, align: right"]2946.58[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1555.80[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1904.75[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1329.10[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1610.25[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1910.30[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1913.08[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1475.23[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1525.80[/TD]
[TD="bgcolor: #D9D9D9, align: right"]553.98[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1329.10[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1904.75[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1560.25[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1337.43[/TD]
[TD="bgcolor: #D9D9D9, align: right"]0.00[/TD]
[TD="bgcolor: #D9D9D9, align: right"]0.00[/TD]
[TD="bgcolor: #D9D9D9, align: right"]0.00[/TD]
[TD="bgcolor: #D9D9D9, align: right"]0.00[/TD]
[TD="bgcolor: #D9D9D9, align: right"]0.00[/TD]
[TD="bgcolor: #D9D9D9, align: right"] 24,193[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"] 770.00[/TD]
[TD="align: right"] 1,670.00[/TD]
[TD="align: right"] 880.00[/TD]
[TD="align: right"] 1,100.00[/TD]
[TD="align: right"] 760.00[/TD]
[TD="align: right"] 900.00[/TD]
[TD="align: right"] 1,080.00[/TD]
[TD="align: right"] 1,070.00[/TD]
[TD="align: right"] 810.00[/TD]
[TD="align: right"] 880.00[/TD]
[TD="align: right"] 310.00[/TD]
[TD="align: right"] 760.00[/TD]
[TD="align: right"] 1,100.00[/TD]
[TD="align: right"] 900.00[/TD]
[TD="align: right"] 730.00[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="bgcolor: #D9D9D9, align: right"] 13,720[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"] 10.00[/TD]
[TD="align: right"] 70.00[/TD]
[TD="align: right"] 40.00[/TD]
[TD="align: right"] 10.00[/TD]
[TD="align: right"] 20.00[/TD]
[TD="align: right"] 60.00[/TD]
[TD="align: right"] 50.00[/TD]
[TD="align: right"] 70.00[/TD]
[TD="align: right"] 80.00[/TD]
[TD="align: right"] 10.00[/TD]
[TD="align: right"] 20.00[/TD]
[TD="align: right"] 20.00[/TD]
[TD="align: right"] 10.00[/TD]
[TD="align: right"] 10.00[/TD]
[TD="align: right"] 80.00[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="bgcolor: #D9D9D9, align: right"] 560[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"] 556.33[/TD]
[TD="align: right"] 1,206.58[/TD]
[TD="align: right"] 635.80[/TD]
[TD="align: right"] 794.75[/TD]
[TD="align: right"] 549.10[/TD]
[TD="align: right"] 650.25[/TD]
[TD="align: right"] 780.30[/TD]
[TD="align: right"] 773.08[/TD]
[TD="align: right"] 585.23[/TD]
[TD="align: right"] 635.80[/TD]
[TD="align: right"] 223.98[/TD]
[TD="align: right"] 549.10[/TD]
[TD="align: right"] 794.75[/TD]
[TD="align: right"] 650.25[/TD]
[TD="align: right"] 527.43[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="bgcolor: #D9D9D9, align: right"] 9,913[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="bgcolor: #D9D9D9"]Section 2[/TD]
[TD="bgcolor: #D9D9D9, align: right"]166.50[/TD]
[TD="bgcolor: #D9D9D9, align: right"]3624.90[/TD]
[TD="bgcolor: #D9D9D9, align: right"]753.15[/TD]
[TD="bgcolor: #D9D9D9, align: right"]82.50[/TD]
[TD="bgcolor: #D9D9D9, align: right"]2290.38[/TD]
[TD="bgcolor: #D9D9D9, align: right"]531.50[/TD]
[TD="bgcolor: #D9D9D9, align: right"]318.35[/TD]
[TD="bgcolor: #D9D9D9, align: right"]6593.48[/TD]
[TD="bgcolor: #D9D9D9, align: right"]924.88[/TD]
[TD="bgcolor: #D9D9D9, align: right"]869.50[/TD]
[TD="bgcolor: #D9D9D9, align: right"]4090.50[/TD]
[TD="bgcolor: #D9D9D9, align: right"]2290.38[/TD]
[TD="bgcolor: #D9D9D9, align: right"]82.50[/TD]
[TD="bgcolor: #D9D9D9, align: right"]2949.13[/TD]
[TD="bgcolor: #D9D9D9, align: right"]1516.65[/TD]
[TD="bgcolor: #D9D9D9, align: right"]0.00[/TD]
[TD="bgcolor: #D9D9D9, align: right"]0.00[/TD]
[TD="bgcolor: #D9D9D9, align: right"]0.00[/TD]
[TD="bgcolor: #D9D9D9, align: right"]0.00[/TD]
[TD="bgcolor: #D9D9D9, align: right"]0.00[/TD]
[TD="bgcolor: #D9D9D9, align: right"] 27,084[/TD]

[TD="align: center"]11[/TD]

[TD="align: right"] -[/TD]
[TD="align: right"] 3,063.40[/TD]
[TD="align: right"] 679.15[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 830.88[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 187.85[/TD]
[TD="align: right"] 801.98[/TD]
[TD="align: right"] 686.38[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,300.50[/TD]
[TD="align: right"] 830.88[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 1,336.63[/TD]
[TD="align: right"] 1,257.15[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="bgcolor: #D9D9D9, align: right"] 10,975[/TD]

[TD="align: center"]12[/TD]

[TD="align: right"] 90.00[/TD]
[TD="align: right"] 60.00[/TD]
[TD="align: right"] 40.00[/TD]
[TD="align: right"] 40.00[/TD]
[TD="align: right"] 720.00[/TD]
[TD="align: right"] 30.00[/TD]
[TD="align: right"] 20.00[/TD]
[TD="align: right"] 20.00[/TD]
[TD="align: right"] 60.00[/TD]
[TD="align: right"] 470.00[/TD]
[TD="align: right"] 1,430.00[/TD]
[TD="align: right"] 720.00[/TD]
[TD="align: right"] 40.00[/TD]
[TD="align: right"] 40.00[/TD]
[TD="align: right"] 30.00[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="bgcolor: #D9D9D9, align: right"] 3,810[/TD]

[TD="align: center"]13[/TD]

[TD="align: right"] 76.50[/TD]
[TD="align: right"] 51.00[/TD]
[TD="align: right"] 34.00[/TD]
[TD="align: right"] 34.00[/TD]
[TD="align: right"] 612.00[/TD]
[TD="align: right"] 25.50[/TD]
[TD="align: right"] 17.00[/TD]
[TD="align: right"] 17.00[/TD]
[TD="align: right"] 51.00[/TD]
[TD="align: right"] 399.50[/TD]
[TD="align: right"] 1,215.50[/TD]
[TD="align: right"] 612.00[/TD]
[TD="align: right"] 34.00[/TD]
[TD="align: right"] 34.00[/TD]
[TD="align: right"] 25.50[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="bgcolor: #D9D9D9, align: right"] 3,239[/TD]

[TD="align: center"]14[/TD]

[TD="align: right"] -[/TD]
[TD="align: right"] 450.50[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 8.50[/TD]
[TD="align: right"] 127.50[/TD]
[TD="align: right"] 476.00[/TD]
[TD="align: right"] 93.50[/TD]
[TD="align: right"] 5,754.50[/TD]
[TD="align: right"] 127.50[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] 144.50[/TD]
[TD="align: right"] 127.50[/TD]
[TD="align: right"] 8.50[/TD]
[TD="align: right"] 1,538.50[/TD]
[TD="align: right"] 204.00[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="align: right"] -[/TD]
[TD="bgcolor: #D9D9D9, align: right"] 9,061[/TD]

</tbody>
Standard Sheet​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #E0E0F0"]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]B4[/TH]
[TD="align: left"]=SUM(B5:B7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]C4[/TH]
[TD="align: left"]=SUM(C5:C7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]D4[/TH]
[TD="align: left"]=SUM(D5:D7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]E4[/TH]
[TD="align: left"]=SUM(E5:E7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]F4[/TH]
[TD="align: left"]=SUM(F5:F7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]G4[/TH]
[TD="align: left"]=SUM(G5:G7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]H4[/TH]
[TD="align: left"]=SUM(H5:H7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]I4[/TH]
[TD="align: left"]=SUM(I5:I7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]J4[/TH]
[TD="align: left"]=SUM(J5:J7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]K4[/TH]
[TD="align: left"]=SUM(K5:K7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]L4[/TH]
[TD="align: left"]=SUM(L5:L7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]M4[/TH]
[TD="align: left"]=SUM(M5:M7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]N4[/TH]
[TD="align: left"]=SUM(N5:N7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]O4[/TH]
[TD="align: left"]=SUM(O5:O7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]P4[/TH]
[TD="align: left"]=SUM(P5:P7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]Q4[/TH]
[TD="align: left"]=SUM(Q5:Q7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]R4[/TH]
[TD="align: left"]=SUM(R5:R7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]S4[/TH]
[TD="align: left"]=SUM(S5:S7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]T4[/TH]
[TD="align: left"]=SUM(T5:T7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]U4[/TH]
[TD="align: left"]=SUM(U5:U7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]V4[/TH]
[TD="align: left"]=SUM(B4:U4)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]B5[/TH]
[TD="align: left"]=INDEX('Source Data'!B4:B22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]C5[/TH]
[TD="align: left"]=INDEX('Source Data'!C4:C22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]D5[/TH]
[TD="align: left"]=INDEX('Source Data'!D4:D22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]E5[/TH]
[TD="align: left"]=INDEX('Source Data'!E4:E22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]F5[/TH]
[TD="align: left"]=INDEX('Source Data'!F4:F22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]G5[/TH]
[TD="align: left"]=INDEX('Source Data'!G4:G22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]H5[/TH]
[TD="align: left"]=INDEX('Source Data'!H4:H22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]I5[/TH]
[TD="align: left"]=INDEX('Source Data'!I4:I22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]J5[/TH]
[TD="align: left"]=INDEX('Source Data'!J4:J22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]K5[/TH]
[TD="align: left"]=INDEX('Source Data'!K4:K22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]L5[/TH]
[TD="align: left"]=INDEX('Source Data'!L4:L22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]M5[/TH]
[TD="align: left"]=INDEX('Source Data'!M4:M22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]N5[/TH]
[TD="align: left"]=INDEX('Source Data'!N4:N22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]O5[/TH]
[TD="align: left"]=INDEX('Source Data'!O4:O22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]P5[/TH]
[TD="align: left"]=INDEX('Source Data'!P4:P22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]Q5[/TH]
[TD="align: left"]=INDEX('Source Data'!Q4:Q22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]R5[/TH]
[TD="align: left"]=INDEX('Source Data'!R4:R22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]S5[/TH]
[TD="align: left"]=INDEX('Source Data'!S4:S22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]T5[/TH]
[TD="align: left"]=INDEX('Source Data'!T4:T22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]U5[/TH]
[TD="align: left"]=INDEX('Source Data'!U4:U22,MATCH([COLOR=#0]"Pear 1",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]V5[/TH]
[TD="align: left"]=SUM(B5:U5)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]B6[/TH]
[TD="align: left"]=INDEX('Source Data'!B4:B22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]C6[/TH]
[TD="align: left"]=INDEX('Source Data'!C4:C22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]D6[/TH]
[TD="align: left"]=INDEX('Source Data'!D4:D22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]E6[/TH]
[TD="align: left"]=INDEX('Source Data'!E4:E22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]F6[/TH]
[TD="align: left"]=INDEX('Source Data'!F4:F22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]G6[/TH]
[TD="align: left"]=INDEX('Source Data'!G4:G22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]H6[/TH]
[TD="align: left"]=INDEX('Source Data'!H4:H22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]I6[/TH]
[TD="align: left"]=INDEX('Source Data'!I4:I22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]J6[/TH]
[TD="align: left"]=INDEX('Source Data'!J4:J22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]K6[/TH]
[TD="align: left"]=INDEX('Source Data'!K4:K22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]L6[/TH]
[TD="align: left"]=INDEX('Source Data'!L4:L22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]M6[/TH]
[TD="align: left"]=INDEX('Source Data'!M4:M22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]N6[/TH]
[TD="align: left"]=INDEX('Source Data'!N4:N22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]O6[/TH]
[TD="align: left"]=INDEX('Source Data'!O4:O22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]P6[/TH]
[TD="align: left"]=INDEX('Source Data'!P4:P22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]Q6[/TH]
[TD="align: left"]=INDEX('Source Data'!Q4:Q22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]R6[/TH]
[TD="align: left"]=INDEX('Source Data'!R4:R22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]S6[/TH]
[TD="align: left"]=INDEX('Source Data'!S4:S22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]T6[/TH]
[TD="align: left"]=INDEX('Source Data'!T4:T22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]U6[/TH]
[TD="align: left"]=INDEX('Source Data'!U4:U22,MATCH([COLOR=#0]"Pear 3",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]V6[/TH]
[TD="align: left"]=SUM(B6:U6)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]B7[/TH]
[TD="align: left"]=INDEX('Source Data'!B4:B22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]C7[/TH]
[TD="align: left"]=INDEX('Source Data'!C4:C22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]D7[/TH]
[TD="align: left"]=INDEX('Source Data'!D4:D22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]E7[/TH]
[TD="align: left"]=INDEX('Source Data'!E4:E22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]F7[/TH]
[TD="align: left"]=INDEX('Source Data'!F4:F22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]G7[/TH]
[TD="align: left"]=INDEX('Source Data'!G4:G22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]H7[/TH]
[TD="align: left"]=INDEX('Source Data'!H4:H22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]I7[/TH]
[TD="align: left"]=INDEX('Source Data'!I4:I22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]J7[/TH]
[TD="align: left"]=INDEX('Source Data'!J4:J22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]K7[/TH]
[TD="align: left"]=INDEX('Source Data'!K4:K22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]L7[/TH]
[TD="align: left"]=INDEX('Source Data'!L4:L22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]M7[/TH]
[TD="align: left"]=INDEX('Source Data'!M4:M22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]N7[/TH]
[TD="align: left"]=INDEX('Source Data'!N4:N22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]O7[/TH]
[TD="align: left"]=INDEX('Source Data'!O4:O22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]P7[/TH]
[TD="align: left"]=INDEX('Source Data'!P4:P22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]Q7[/TH]
[TD="align: left"]=INDEX('Source Data'!Q4:Q22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]R7[/TH]
[TD="align: left"]=INDEX('Source Data'!R4:R22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]S7[/TH]
[TD="align: left"]=INDEX('Source Data'!S4:S22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]T7[/TH]
[TD="align: left"]=INDEX('Source Data'!T4:T22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]U7[/TH]
[TD="align: left"]=INDEX('Source Data'!U4:U22,MATCH([COLOR=#0]"Pear 11",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]V7[/TH]
[TD="align: left"]=SUM(B7:U7)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]B10[/TH]
[TD="align: left"]=SUM(B11:B14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]C10[/TH]
[TD="align: left"]=SUM(C11:C14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]D10[/TH]
[TD="align: left"]=SUM(D11:D14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]E10[/TH]
[TD="align: left"]=SUM(E11:E14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]F10[/TH]
[TD="align: left"]=SUM(F11:F14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]G10[/TH]
[TD="align: left"]=SUM(G11:G14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]H10[/TH]
[TD="align: left"]=SUM(H11:H14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]I10[/TH]
[TD="align: left"]=SUM(I11:I14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]J10[/TH]
[TD="align: left"]=SUM(J11:J14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]K10[/TH]
[TD="align: left"]=SUM(K11:K14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]L10[/TH]
[TD="align: left"]=SUM(L11:L14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]M10[/TH]
[TD="align: left"]=SUM(M11:M14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]N10[/TH]
[TD="align: left"]=SUM(N11:N14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]O10[/TH]
[TD="align: left"]=SUM(O11:O14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]P10[/TH]
[TD="align: left"]=SUM(P11:P14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]Q10[/TH]
[TD="align: left"]=SUM(Q11:Q14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]R10[/TH]
[TD="align: left"]=SUM(R11:R14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]S10[/TH]
[TD="align: left"]=SUM(S11:S14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]T10[/TH]
[TD="align: left"]=SUM(T11:T14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]U10[/TH]
[TD="align: left"]=SUM(U11:U14)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]V10[/TH]
[TD="align: left"]=SUM(B10:U10)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]B11[/TH]
[TD="align: left"]=INDEX('Source Data'!B4:B22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]C11[/TH]
[TD="align: left"]=INDEX('Source Data'!C4:C22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]D11[/TH]
[TD="align: left"]=INDEX('Source Data'!D4:D22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]E11[/TH]
[TD="align: left"]=INDEX('Source Data'!E4:E22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]F11[/TH]
[TD="align: left"]=INDEX('Source Data'!F4:F22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]G11[/TH]
[TD="align: left"]=INDEX('Source Data'!G4:G22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]H11[/TH]
[TD="align: left"]=INDEX('Source Data'!H4:H22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]I11[/TH]
[TD="align: left"]=INDEX('Source Data'!I4:I22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]J11[/TH]
[TD="align: left"]=INDEX('Source Data'!J4:J22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]K11[/TH]
[TD="align: left"]=INDEX('Source Data'!K4:K22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]L11[/TH]
[TD="align: left"]=INDEX('Source Data'!L4:L22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]M11[/TH]
[TD="align: left"]=INDEX('Source Data'!M4:M22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]N11[/TH]
[TD="align: left"]=INDEX('Source Data'!N4:N22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]O11[/TH]
[TD="align: left"]=INDEX('Source Data'!O4:O22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]P11[/TH]
[TD="align: left"]=INDEX('Source Data'!P4:P22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]Q11[/TH]
[TD="align: left"]=INDEX('Source Data'!Q4:Q22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]R11[/TH]
[TD="align: left"]=INDEX('Source Data'!R4:R22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]S11[/TH]
[TD="align: left"]=INDEX('Source Data'!S4:S22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]T11[/TH]
[TD="align: left"]=INDEX('Source Data'!T4:T22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]U11[/TH]
[TD="align: left"]=INDEX('Source Data'!U4:U22,MATCH([COLOR=#0]"Pear 14",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]V11[/TH]
[TD="align: left"]=SUM(B11:U11)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]B12[/TH]
[TD="align: left"]=INDEX('Source Data'!B4:B22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]C12[/TH]
[TD="align: left"]=INDEX('Source Data'!C4:C22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]D12[/TH]
[TD="align: left"]=INDEX('Source Data'!D4:D22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]E12[/TH]
[TD="align: left"]=INDEX('Source Data'!E4:E22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]F12[/TH]
[TD="align: left"]=INDEX('Source Data'!F4:F22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]G12[/TH]
[TD="align: left"]=INDEX('Source Data'!G4:G22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]H12[/TH]
[TD="align: left"]=INDEX('Source Data'!H4:H22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]I12[/TH]
[TD="align: left"]=INDEX('Source Data'!I4:I22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]J12[/TH]
[TD="align: left"]=INDEX('Source Data'!J4:J22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]K12[/TH]
[TD="align: left"]=INDEX('Source Data'!K4:K22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]L12[/TH]
[TD="align: left"]=INDEX('Source Data'!L4:L22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]M12[/TH]
[TD="align: left"]=INDEX('Source Data'!M4:M22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]N12[/TH]
[TD="align: left"]=INDEX('Source Data'!N4:N22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]O12[/TH]
[TD="align: left"]=INDEX('Source Data'!O4:O22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]P12[/TH]
[TD="align: left"]=INDEX('Source Data'!P4:P22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]Q12[/TH]
[TD="align: left"]=INDEX('Source Data'!Q4:Q22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]R12[/TH]
[TD="align: left"]=INDEX('Source Data'!R4:R22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]S12[/TH]
[TD="align: left"]=INDEX('Source Data'!S4:S22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]T12[/TH]
[TD="align: left"]=INDEX('Source Data'!T4:T22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]U12[/TH]
[TD="align: left"]=INDEX('Source Data'!U4:U22,MATCH([COLOR=#0]"Pear 2",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]V12[/TH]
[TD="align: left"]=SUM(B12:U12)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]B13[/TH]
[TD="align: left"]=INDEX('Source Data'!B4:B22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]C13[/TH]
[TD="align: left"]=INDEX('Source Data'!C4:C22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]D13[/TH]
[TD="align: left"]=INDEX('Source Data'!D4:D22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]E13[/TH]
[TD="align: left"]=INDEX('Source Data'!E4:E22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]F13[/TH]
[TD="align: left"]=INDEX('Source Data'!F4:F22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]G13[/TH]
[TD="align: left"]=INDEX('Source Data'!G4:G22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]H13[/TH]
[TD="align: left"]=INDEX('Source Data'!H4:H22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]I13[/TH]
[TD="align: left"]=INDEX('Source Data'!I4:I22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]J13[/TH]
[TD="align: left"]=INDEX('Source Data'!J4:J22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]K13[/TH]
[TD="align: left"]=INDEX('Source Data'!K4:K22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]L13[/TH]
[TD="align: left"]=INDEX('Source Data'!L4:L22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]M13[/TH]
[TD="align: left"]=INDEX('Source Data'!M4:M22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]N13[/TH]
[TD="align: left"]=INDEX('Source Data'!N4:N22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]O13[/TH]
[TD="align: left"]=INDEX('Source Data'!O4:O22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]P13[/TH]
[TD="align: left"]=INDEX('Source Data'!P4:P22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]Q13[/TH]
[TD="align: left"]=INDEX('Source Data'!Q4:Q22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]R13[/TH]
[TD="align: left"]=INDEX('Source Data'!R4:R22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]S13[/TH]
[TD="align: left"]=INDEX('Source Data'!S4:S22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]T13[/TH]
[TD="align: left"]=INDEX('Source Data'!T4:T22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]U13[/TH]
[TD="align: left"]=INDEX('Source Data'!U4:U22,MATCH([COLOR=#0]"Pear 7",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]V13[/TH]
[TD="align: left"]=SUM(B13:U13)[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]B14[/TH]
[TD="align: left"]=INDEX('Source Data'!B4:B22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]C14[/TH]
[TD="align: left"]=INDEX('Source Data'!C4:C22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]D14[/TH]
[TD="align: left"]=INDEX('Source Data'!D4:D22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]E14[/TH]
[TD="align: left"]=INDEX('Source Data'!E4:E22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]F14[/TH]
[TD="align: left"]=INDEX('Source Data'!F4:F22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]G14[/TH]
[TD="align: left"]=INDEX('Source Data'!G4:G22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]H14[/TH]
[TD="align: left"]=INDEX('Source Data'!H4:H22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]I14[/TH]
[TD="align: left"]=INDEX('Source Data'!I4:I22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]J14[/TH]
[TD="align: left"]=INDEX('Source Data'!J4:J22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]K14[/TH]
[TD="align: left"]=INDEX('Source Data'!K4:K22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]L14[/TH]
[TD="align: left"]=INDEX('Source Data'!L4:L22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]M14[/TH]
[TD="align: left"]=INDEX('Source Data'!M4:M22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]N14[/TH]
[TD="align: left"]=INDEX('Source Data'!N4:N22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]O14[/TH]
[TD="align: left"]=INDEX('Source Data'!O4:O22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]P14[/TH]
[TD="align: left"]=INDEX('Source Data'!P4:P22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]Q14[/TH]
[TD="align: left"]=INDEX('Source Data'!Q4:Q22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]R14[/TH]
[TD="align: left"]=INDEX('Source Data'!R4:R22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]S14[/TH]
[TD="align: left"]=INDEX('Source Data'!S4:S22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]T14[/TH]
[TD="align: left"]=INDEX('Source Data'!T4:T22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]U14[/TH]
[TD="align: left"]=INDEX('Source Data'!U4:U22,MATCH([COLOR=#0]"Pear 10",'Source Data'!$A$4:$A$22,0)[/COLOR])[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: #E0E0F0"]V14[/TH]
[TD="align: left"]=SUM(B14:U14)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited by a moderator:

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
I think you need an Index Match Match to get the correct value.

Try this in Standard Sheet B5: =IFERROR(INDEX('Source Data'!$A$1:$P$22,MATCH('Standard Sheet'!$A5,'Source Data'!$A$1:$A$22,0),MATCH('Standard Sheet'!B$1,'Source Data'!$A$1:$P$1,0),1),0)

Then drag that formula down and across to populate your section numbers.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Asbestos_Jen
  • Question Question
Compare multiple parameters of samples to reference values (Excel 2007)
Replies
3
Views
338
Asbestos_Jen
Asbestos_Jen
C
  • Solved
index match excel formula to vba code
Replies
9
Views
319
DanteAmor
DanteAmor
P
  • Solved
Substituting Filter function in Excel 2016
Replies
5
Views
345
AhoyNC
A
C
  • Question Question
Sum Horizontal and Vertical
Replies
2
Views
185
ChetanPuri
C
T
  • Question Question
RAINFALL CESSATION DATE USING INDEX
Replies
1
Views
228
Thlama
T

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top