How do I let Microsoft know that there's a glitch in Excel 2010 that needs fixing?
This has been replicated across three different computers now. I don't know where to upload the file so I'll just copy paste the results and then the equations for the proof below if you wish to replicate.
You can see there's a completely mis-matched pattern of errors with the Match function depending how the numbers were created... for curiosities sake I did also create parallel tables running if() equations confirming the numbers were as they say they are and they all came up True, indicating that according to the if() equation the numbers are identical and therefor SHOULD match.
[TABLE="width: 720"]
<colgroup><col width="72" span="10" style="width:54pt"> </colgroup><tbody>[TR]
[TD="class: xl73, width: 72"]Lookup Array[/TD]
[TD="class: xl74, width: 72, align: right"]0.1[/TD]
[TD="class: xl74, width: 72, align: right"]0.2[/TD]
[TD="class: xl74, width: 72, align: right"]0.3[/TD]
[TD="class: xl74, width: 72, align: right"]0.4[/TD]
[TD="class: xl74, width: 72, align: right"]0.5[/TD]
[TD="class: xl74, width: 72, align: right"]0.6[/TD]
[TD="class: xl74, width: 72, align: right"]0.7[/TD]
[TD="class: xl74, width: 72, align: right"]0.8[/TD]
[TD="class: xl75, width: 72, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl70"]Pre-rounded[/TD]
[TD="class: xl71, align: right"]0.01[/TD]
[TD="class: xl71, align: right"]0.12[/TD]
[TD="class: xl71, align: right"]0.23[/TD]
[TD="class: xl71, align: right"]0.34[/TD]
[TD="class: xl71, align: right"]0.45[/TD]
[TD="class: xl71, align: right"]0.56[/TD]
[TD="class: xl71, align: right"]0.67[/TD]
[TD="class: xl71, align: right"]0.78[/TD]
[TD="class: xl72, align: right"]0.89[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]re-typed[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"] [/TD]
[TD="class: xl63, colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl66, align: right"]9[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]#N/A[/TD]
[TD="class: xl66, align: right"]9[/TD]
[/TR]
[TR]
[TD="class: xl67"]re-typed[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]2[/TD]
[TD="class: xl68, align: right"]3[/TD]
[TD="class: xl68, align: right"]4[/TD]
[TD="class: xl68, align: right"]5[/TD]
[TD="class: xl68, align: right"]6[/TD]
[TD="class: xl68, align: right"]7[/TD]
[TD="class: xl68, align: right"]8[/TD]
[TD="class: xl69, align: right"]9[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl77, colspan: 9"]Equation based Lookup Array[/TD]
[/TR]
[TR]
[TD="class: xl73"]Lookup Array[/TD]
[TD="class: xl74, align: right"]0.1[/TD]
[TD="class: xl74, align: right"]0.2[/TD]
[TD="class: xl74, align: right"]0.3[/TD]
[TD="class: xl74, align: right"]0.4[/TD]
[TD="class: xl74, align: right"]0.5[/TD]
[TD="class: xl74, align: right"]0.6[/TD]
[TD="class: xl74, align: right"]0.7[/TD]
[TD="class: xl74, align: right"]0.8[/TD]
[TD="class: xl75, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl70"]Pre-rounded[/TD]
[TD="class: xl71, align: right"]0.01[/TD]
[TD="class: xl71, align: right"]0.12[/TD]
[TD="class: xl71, align: right"]0.23[/TD]
[TD="class: xl71, align: right"]0.34[/TD]
[TD="class: xl71, align: right"]0.45[/TD]
[TD="class: xl71, align: right"]0.56[/TD]
[TD="class: xl71, align: right"]0.67[/TD]
[TD="class: xl71, align: right"]0.78[/TD]
[TD="class: xl72, align: right"]0.89[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]re-typed[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"] [/TD]
[TD="class: xl63, colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl67"]re-typed[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: right"]5[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: right"]7[/TD]
[TD="class: xl68, align: right"]8[/TD]
[TD="class: xl69, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl77, colspan: 9"]Cumulative Equation based Lookup Array[/TD]
[/TR]
[TR]
[TD="class: xl73"]Lookup Array[/TD]
[TD="class: xl74, align: right"]0.1[/TD]
[TD="class: xl74, align: right"]0.2[/TD]
[TD="class: xl74, align: right"]0.3[/TD]
[TD="class: xl74, align: right"]0.4[/TD]
[TD="class: xl74, align: right"]0.5[/TD]
[TD="class: xl74, align: right"]0.6[/TD]
[TD="class: xl74, align: right"]0.7[/TD]
[TD="class: xl74, align: right"]0.8[/TD]
[TD="class: xl75, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl70"]Pre-rounded[/TD]
[TD="class: xl71, align: right"]0.01[/TD]
[TD="class: xl71, align: right"]0.12[/TD]
[TD="class: xl71, align: right"]0.23[/TD]
[TD="class: xl71, align: right"]0.34[/TD]
[TD="class: xl71, align: right"]0.45[/TD]
[TD="class: xl71, align: right"]0.56[/TD]
[TD="class: xl71, align: right"]0.67[/TD]
[TD="class: xl71, align: right"]0.78[/TD]
[TD="class: xl72, align: right"]0.89[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]re-typed[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"] [/TD]
[TD="class: xl63, colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl67"]re-typed[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]2[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: right"]4[/TD]
[TD="class: xl68, align: right"]5[/TD]
[TD="class: xl68, align: right"]6[/TD]
[TD="class: xl68, align: right"]7[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl69, align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1494"]
<colgroup><col><col span="9"></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 9"]Typed Lookup Array[/TD]
[/TR]
[TR]
[TD]Lookup Array[/TD]
[TD]0.1[/TD]
[TD]0.2[/TD]
[TD]0.3[/TD]
[TD]0.4[/TD]
[TD]0.5[/TD]
[TD]0.6[/TD]
[TD]0.7[/TD]
[TD]0.8[/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD]Pre-rounded[/TD]
[TD]0.01[/TD]
[TD]0.12[/TD]
[TD]0.23[/TD]
[TD]0.34[/TD]
[TD]0.45[/TD]
[TD]0.56[/TD]
[TD]0.67[/TD]
[TD]0.78[/TD]
[TD]0.89[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=CEILING(B3,0.1)[/TD]
[TD]=CEILING(C3,0.1)[/TD]
[TD]=CEILING(D3,0.1)[/TD]
[TD]=CEILING(E3,0.1)[/TD]
[TD]=CEILING(F3,0.1)[/TD]
[TD]=CEILING(G3,0.1)[/TD]
[TD]=CEILING(H3,0.1)[/TD]
[TD]=CEILING(I3,0.1)[/TD]
[TD]=CEILING(J3,0.1)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=ROUNDUP(B3,1)[/TD]
[TD]=ROUNDUP(C3,1)[/TD]
[TD]=ROUNDUP(D3,1)[/TD]
[TD]=ROUNDUP(E3,1)[/TD]
[TD]=ROUNDUP(F3,1)[/TD]
[TD]=ROUNDUP(G3,1)[/TD]
[TD]=ROUNDUP(H3,1)[/TD]
[TD]=ROUNDUP(I3,1)[/TD]
[TD]=ROUNDUP(J3,1)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]0.1[/TD]
[TD]0.2[/TD]
[TD]0.3[/TD]
[TD]0.4[/TD]
[TD]0.5[/TD]
[TD]0.6[/TD]
[TD]0.7[/TD]
[TD]0.8[/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=MATCH(B4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(C4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(D4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(E4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(F4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(G4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(H4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(I4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(J4,$B$2:$J$2,0)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=MATCH(B5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(C5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(D5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(E5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(F5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(G5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(H5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(I5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(J5,$B$2:$J$2,0)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]=MATCH(B6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(C6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(D6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(E6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(F6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(G6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(H6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(I6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(J6,$B$2:$J$2,0)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 9"]Equation based Lookup Array[/TD]
[/TR]
[TR]
[TD]Lookup Array[/TD]
[TD]=B2+1-1[/TD]
[TD]=C2+1-1[/TD]
[TD]=D2+1-1[/TD]
[TD]=E2+1-1[/TD]
[TD]=F2+1-1[/TD]
[TD]=G2+1-1[/TD]
[TD]=H2+1-1[/TD]
[TD]=I2+1-1[/TD]
[TD]=J2+1-1[/TD]
[/TR]
[TR]
[TD]Pre-rounded[/TD]
[TD]0.01[/TD]
[TD]0.12[/TD]
[TD]0.23[/TD]
[TD]0.34[/TD]
[TD]0.45[/TD]
[TD]0.56[/TD]
[TD]0.67[/TD]
[TD]0.78[/TD]
[TD]0.89[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=CEILING(B15,0.1)[/TD]
[TD]=CEILING(C15,0.1)[/TD]
[TD]=CEILING(D15,0.1)[/TD]
[TD]=CEILING(E15,0.1)[/TD]
[TD]=CEILING(F15,0.1)[/TD]
[TD]=CEILING(G15,0.1)[/TD]
[TD]=CEILING(H15,0.1)[/TD]
[TD]=CEILING(I15,0.1)[/TD]
[TD]=CEILING(J15,0.1)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=ROUNDUP(B15,1)[/TD]
[TD]=ROUNDUP(C15,1)[/TD]
[TD]=ROUNDUP(D15,1)[/TD]
[TD]=ROUNDUP(E15,1)[/TD]
[TD]=ROUNDUP(F15,1)[/TD]
[TD]=ROUNDUP(G15,1)[/TD]
[TD]=ROUNDUP(H15,1)[/TD]
[TD]=ROUNDUP(I15,1)[/TD]
[TD]=ROUNDUP(J15,1)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]0.1[/TD]
[TD]0.2[/TD]
[TD]0.3[/TD]
[TD]0.4[/TD]
[TD]0.5[/TD]
[TD]0.6[/TD]
[TD]0.7[/TD]
[TD]0.8[/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=MATCH(B16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(C16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(D16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(E16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(F16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(G16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(H16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(I16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(J16,$B$14:$J$14,0)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=MATCH(B17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(C17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(D17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(E17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(F17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(G17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(H17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(I17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(J17,$B$14:$J$14,0)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]=MATCH(B18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(C18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(D18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(E18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(F18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(G18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(H18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(I18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(J18,$B$14:$J$14,0)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 9"]Cumulative Equation based Lookup Array[/TD]
[/TR]
[TR]
[TD]Lookup Array[/TD]
[TD]0.1[/TD]
[TD]=B26+0.1[/TD]
[TD]=C26+0.1[/TD]
[TD]=D26+0.1[/TD]
[TD]=E26+0.1[/TD]
[TD]=F26+0.1[/TD]
[TD]=G26+0.1[/TD]
[TD]=H26+0.1[/TD]
[TD]=I26+0.1[/TD]
[/TR]
[TR]
[TD]Pre-rounded[/TD]
[TD]0.01[/TD]
[TD]0.12[/TD]
[TD]0.23[/TD]
[TD]0.34[/TD]
[TD]0.45[/TD]
[TD]0.56[/TD]
[TD]0.67[/TD]
[TD]0.78[/TD]
[TD]0.89[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=CEILING(B27,0.1)[/TD]
[TD]=CEILING(C27,0.1)[/TD]
[TD]=CEILING(D27,0.1)[/TD]
[TD]=CEILING(E27,0.1)[/TD]
[TD]=CEILING(F27,0.1)[/TD]
[TD]=CEILING(G27,0.1)[/TD]
[TD]=CEILING(H27,0.1)[/TD]
[TD]=CEILING(I27,0.1)[/TD]
[TD]=CEILING(J27,0.1)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=ROUNDUP(B27,1)[/TD]
[TD]=ROUNDUP(C27,1)[/TD]
[TD]=ROUNDUP(D27,1)[/TD]
[TD]=ROUNDUP(E27,1)[/TD]
[TD]=ROUNDUP(F27,1)[/TD]
[TD]=ROUNDUP(G27,1)[/TD]
[TD]=ROUNDUP(H27,1)[/TD]
[TD]=ROUNDUP(I27,1)[/TD]
[TD]=ROUNDUP(J27,1)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]0.1[/TD]
[TD]0.2[/TD]
[TD]0.3[/TD]
[TD]0.4[/TD]
[TD]0.5[/TD]
[TD]0.6[/TD]
[TD]0.7[/TD]
[TD]0.8[/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=MATCH(B28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(C28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(D28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(E28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(F28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(G28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(H28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(I28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(J28,$B$26:$J$26,0)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=MATCH(B29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(C29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(D29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(E29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(F29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(G29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(H29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(I29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(J29,$B$26:$J$26,0)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]=MATCH(B30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(C30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(D30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(E30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(F30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(G30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(H30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(I30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(J30,$B$26:$J$26,0)[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1494"]
<tbody>[TR]
[TD="colspan: 9"]Typed Lookup Array[/TD]
[/TR]
</tbody>[/TABLE]
This has been replicated across three different computers now. I don't know where to upload the file so I'll just copy paste the results and then the equations for the proof below if you wish to replicate.
You can see there's a completely mis-matched pattern of errors with the Match function depending how the numbers were created... for curiosities sake I did also create parallel tables running if() equations confirming the numbers were as they say they are and they all came up True, indicating that according to the if() equation the numbers are identical and therefor SHOULD match.
[TABLE="width: 720"]
<colgroup><col width="72" span="10" style="width:54pt"> </colgroup><tbody>[TR]
[TD="class: xl73, width: 72"]Lookup Array[/TD]
[TD="class: xl74, width: 72, align: right"]0.1[/TD]
[TD="class: xl74, width: 72, align: right"]0.2[/TD]
[TD="class: xl74, width: 72, align: right"]0.3[/TD]
[TD="class: xl74, width: 72, align: right"]0.4[/TD]
[TD="class: xl74, width: 72, align: right"]0.5[/TD]
[TD="class: xl74, width: 72, align: right"]0.6[/TD]
[TD="class: xl74, width: 72, align: right"]0.7[/TD]
[TD="class: xl74, width: 72, align: right"]0.8[/TD]
[TD="class: xl75, width: 72, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl70"]Pre-rounded[/TD]
[TD="class: xl71, align: right"]0.01[/TD]
[TD="class: xl71, align: right"]0.12[/TD]
[TD="class: xl71, align: right"]0.23[/TD]
[TD="class: xl71, align: right"]0.34[/TD]
[TD="class: xl71, align: right"]0.45[/TD]
[TD="class: xl71, align: right"]0.56[/TD]
[TD="class: xl71, align: right"]0.67[/TD]
[TD="class: xl71, align: right"]0.78[/TD]
[TD="class: xl72, align: right"]0.89[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]re-typed[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"] [/TD]
[TD="class: xl63, colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl66, align: right"]9[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]#N/A[/TD]
[TD="class: xl66, align: right"]9[/TD]
[/TR]
[TR]
[TD="class: xl67"]re-typed[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]2[/TD]
[TD="class: xl68, align: right"]3[/TD]
[TD="class: xl68, align: right"]4[/TD]
[TD="class: xl68, align: right"]5[/TD]
[TD="class: xl68, align: right"]6[/TD]
[TD="class: xl68, align: right"]7[/TD]
[TD="class: xl68, align: right"]8[/TD]
[TD="class: xl69, align: right"]9[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl77, colspan: 9"]Equation based Lookup Array[/TD]
[/TR]
[TR]
[TD="class: xl73"]Lookup Array[/TD]
[TD="class: xl74, align: right"]0.1[/TD]
[TD="class: xl74, align: right"]0.2[/TD]
[TD="class: xl74, align: right"]0.3[/TD]
[TD="class: xl74, align: right"]0.4[/TD]
[TD="class: xl74, align: right"]0.5[/TD]
[TD="class: xl74, align: right"]0.6[/TD]
[TD="class: xl74, align: right"]0.7[/TD]
[TD="class: xl74, align: right"]0.8[/TD]
[TD="class: xl75, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl70"]Pre-rounded[/TD]
[TD="class: xl71, align: right"]0.01[/TD]
[TD="class: xl71, align: right"]0.12[/TD]
[TD="class: xl71, align: right"]0.23[/TD]
[TD="class: xl71, align: right"]0.34[/TD]
[TD="class: xl71, align: right"]0.45[/TD]
[TD="class: xl71, align: right"]0.56[/TD]
[TD="class: xl71, align: right"]0.67[/TD]
[TD="class: xl71, align: right"]0.78[/TD]
[TD="class: xl72, align: right"]0.89[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]re-typed[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"] [/TD]
[TD="class: xl63, colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]3[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: right"]7[/TD]
[TD="align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl67"]re-typed[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: right"]5[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: right"]7[/TD]
[TD="class: xl68, align: right"]8[/TD]
[TD="class: xl69, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"] [/TD]
[TD="class: xl77, colspan: 9"]Cumulative Equation based Lookup Array[/TD]
[/TR]
[TR]
[TD="class: xl73"]Lookup Array[/TD]
[TD="class: xl74, align: right"]0.1[/TD]
[TD="class: xl74, align: right"]0.2[/TD]
[TD="class: xl74, align: right"]0.3[/TD]
[TD="class: xl74, align: right"]0.4[/TD]
[TD="class: xl74, align: right"]0.5[/TD]
[TD="class: xl74, align: right"]0.6[/TD]
[TD="class: xl74, align: right"]0.7[/TD]
[TD="class: xl74, align: right"]0.8[/TD]
[TD="class: xl75, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl70"]Pre-rounded[/TD]
[TD="class: xl71, align: right"]0.01[/TD]
[TD="class: xl71, align: right"]0.12[/TD]
[TD="class: xl71, align: right"]0.23[/TD]
[TD="class: xl71, align: right"]0.34[/TD]
[TD="class: xl71, align: right"]0.45[/TD]
[TD="class: xl71, align: right"]0.56[/TD]
[TD="class: xl71, align: right"]0.67[/TD]
[TD="class: xl71, align: right"]0.78[/TD]
[TD="class: xl72, align: right"]0.89[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"]re-typed[/TD]
[TD="align: right"]0.1[/TD]
[TD="align: right"]0.2[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]0.6[/TD]
[TD="align: right"]0.7[/TD]
[TD="align: right"]0.8[/TD]
[TD="class: xl66, align: right"]0.9[/TD]
[/TR]
[TR]
[TD="class: xl65"] [/TD]
[TD="class: xl63, colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD="class: xl65"]Ceiling[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="align: center"]#N/A[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl65"]Roundup[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD="class: xl66, align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="class: xl67"]re-typed[/TD]
[TD="class: xl68, align: right"]1[/TD]
[TD="class: xl68, align: right"]2[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl68, align: right"]4[/TD]
[TD="class: xl68, align: right"]5[/TD]
[TD="class: xl68, align: right"]6[/TD]
[TD="class: xl68, align: right"]7[/TD]
[TD="class: xl68, align: center"]#N/A[/TD]
[TD="class: xl69, align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1494"]
<colgroup><col><col span="9"></colgroup><tbody>[TR]
[TD] [/TD]
[TD="colspan: 9"]Typed Lookup Array[/TD]
[/TR]
[TR]
[TD]Lookup Array[/TD]
[TD]0.1[/TD]
[TD]0.2[/TD]
[TD]0.3[/TD]
[TD]0.4[/TD]
[TD]0.5[/TD]
[TD]0.6[/TD]
[TD]0.7[/TD]
[TD]0.8[/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD]Pre-rounded[/TD]
[TD]0.01[/TD]
[TD]0.12[/TD]
[TD]0.23[/TD]
[TD]0.34[/TD]
[TD]0.45[/TD]
[TD]0.56[/TD]
[TD]0.67[/TD]
[TD]0.78[/TD]
[TD]0.89[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=CEILING(B3,0.1)[/TD]
[TD]=CEILING(C3,0.1)[/TD]
[TD]=CEILING(D3,0.1)[/TD]
[TD]=CEILING(E3,0.1)[/TD]
[TD]=CEILING(F3,0.1)[/TD]
[TD]=CEILING(G3,0.1)[/TD]
[TD]=CEILING(H3,0.1)[/TD]
[TD]=CEILING(I3,0.1)[/TD]
[TD]=CEILING(J3,0.1)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=ROUNDUP(B3,1)[/TD]
[TD]=ROUNDUP(C3,1)[/TD]
[TD]=ROUNDUP(D3,1)[/TD]
[TD]=ROUNDUP(E3,1)[/TD]
[TD]=ROUNDUP(F3,1)[/TD]
[TD]=ROUNDUP(G3,1)[/TD]
[TD]=ROUNDUP(H3,1)[/TD]
[TD]=ROUNDUP(I3,1)[/TD]
[TD]=ROUNDUP(J3,1)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]0.1[/TD]
[TD]0.2[/TD]
[TD]0.3[/TD]
[TD]0.4[/TD]
[TD]0.5[/TD]
[TD]0.6[/TD]
[TD]0.7[/TD]
[TD]0.8[/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=MATCH(B4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(C4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(D4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(E4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(F4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(G4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(H4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(I4,$B$2:$J$2,0)[/TD]
[TD]=MATCH(J4,$B$2:$J$2,0)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=MATCH(B5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(C5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(D5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(E5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(F5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(G5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(H5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(I5,$B$2:$J$2,0)[/TD]
[TD]=MATCH(J5,$B$2:$J$2,0)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]=MATCH(B6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(C6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(D6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(E6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(F6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(G6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(H6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(I6,$B$2:$J$2,0)[/TD]
[TD]=MATCH(J6,$B$2:$J$2,0)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 9"]Equation based Lookup Array[/TD]
[/TR]
[TR]
[TD]Lookup Array[/TD]
[TD]=B2+1-1[/TD]
[TD]=C2+1-1[/TD]
[TD]=D2+1-1[/TD]
[TD]=E2+1-1[/TD]
[TD]=F2+1-1[/TD]
[TD]=G2+1-1[/TD]
[TD]=H2+1-1[/TD]
[TD]=I2+1-1[/TD]
[TD]=J2+1-1[/TD]
[/TR]
[TR]
[TD]Pre-rounded[/TD]
[TD]0.01[/TD]
[TD]0.12[/TD]
[TD]0.23[/TD]
[TD]0.34[/TD]
[TD]0.45[/TD]
[TD]0.56[/TD]
[TD]0.67[/TD]
[TD]0.78[/TD]
[TD]0.89[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=CEILING(B15,0.1)[/TD]
[TD]=CEILING(C15,0.1)[/TD]
[TD]=CEILING(D15,0.1)[/TD]
[TD]=CEILING(E15,0.1)[/TD]
[TD]=CEILING(F15,0.1)[/TD]
[TD]=CEILING(G15,0.1)[/TD]
[TD]=CEILING(H15,0.1)[/TD]
[TD]=CEILING(I15,0.1)[/TD]
[TD]=CEILING(J15,0.1)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=ROUNDUP(B15,1)[/TD]
[TD]=ROUNDUP(C15,1)[/TD]
[TD]=ROUNDUP(D15,1)[/TD]
[TD]=ROUNDUP(E15,1)[/TD]
[TD]=ROUNDUP(F15,1)[/TD]
[TD]=ROUNDUP(G15,1)[/TD]
[TD]=ROUNDUP(H15,1)[/TD]
[TD]=ROUNDUP(I15,1)[/TD]
[TD]=ROUNDUP(J15,1)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]0.1[/TD]
[TD]0.2[/TD]
[TD]0.3[/TD]
[TD]0.4[/TD]
[TD]0.5[/TD]
[TD]0.6[/TD]
[TD]0.7[/TD]
[TD]0.8[/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=MATCH(B16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(C16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(D16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(E16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(F16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(G16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(H16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(I16,$B$14:$J$14,0)[/TD]
[TD]=MATCH(J16,$B$14:$J$14,0)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=MATCH(B17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(C17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(D17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(E17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(F17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(G17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(H17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(I17,$B$14:$J$14,0)[/TD]
[TD]=MATCH(J17,$B$14:$J$14,0)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]=MATCH(B18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(C18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(D18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(E18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(F18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(G18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(H18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(I18,$B$14:$J$14,0)[/TD]
[TD]=MATCH(J18,$B$14:$J$14,0)[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 9"]Cumulative Equation based Lookup Array[/TD]
[/TR]
[TR]
[TD]Lookup Array[/TD]
[TD]0.1[/TD]
[TD]=B26+0.1[/TD]
[TD]=C26+0.1[/TD]
[TD]=D26+0.1[/TD]
[TD]=E26+0.1[/TD]
[TD]=F26+0.1[/TD]
[TD]=G26+0.1[/TD]
[TD]=H26+0.1[/TD]
[TD]=I26+0.1[/TD]
[/TR]
[TR]
[TD]Pre-rounded[/TD]
[TD]0.01[/TD]
[TD]0.12[/TD]
[TD]0.23[/TD]
[TD]0.34[/TD]
[TD]0.45[/TD]
[TD]0.56[/TD]
[TD]0.67[/TD]
[TD]0.78[/TD]
[TD]0.89[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=CEILING(B27,0.1)[/TD]
[TD]=CEILING(C27,0.1)[/TD]
[TD]=CEILING(D27,0.1)[/TD]
[TD]=CEILING(E27,0.1)[/TD]
[TD]=CEILING(F27,0.1)[/TD]
[TD]=CEILING(G27,0.1)[/TD]
[TD]=CEILING(H27,0.1)[/TD]
[TD]=CEILING(I27,0.1)[/TD]
[TD]=CEILING(J27,0.1)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=ROUNDUP(B27,1)[/TD]
[TD]=ROUNDUP(C27,1)[/TD]
[TD]=ROUNDUP(D27,1)[/TD]
[TD]=ROUNDUP(E27,1)[/TD]
[TD]=ROUNDUP(F27,1)[/TD]
[TD]=ROUNDUP(G27,1)[/TD]
[TD]=ROUNDUP(H27,1)[/TD]
[TD]=ROUNDUP(I27,1)[/TD]
[TD]=ROUNDUP(J27,1)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]0.1[/TD]
[TD]0.2[/TD]
[TD]0.3[/TD]
[TD]0.4[/TD]
[TD]0.5[/TD]
[TD]0.6[/TD]
[TD]0.7[/TD]
[TD]0.8[/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="colspan: 9"]Match Equations[/TD]
[/TR]
[TR]
[TD]Ceiling[/TD]
[TD]=MATCH(B28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(C28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(D28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(E28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(F28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(G28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(H28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(I28,$B$26:$J$26,0)[/TD]
[TD]=MATCH(J28,$B$26:$J$26,0)[/TD]
[/TR]
[TR]
[TD]Roundup[/TD]
[TD]=MATCH(B29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(C29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(D29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(E29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(F29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(G29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(H29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(I29,$B$26:$J$26,0)[/TD]
[TD]=MATCH(J29,$B$26:$J$26,0)[/TD]
[/TR]
[TR]
[TD]re-typed[/TD]
[TD]=MATCH(B30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(C30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(D30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(E30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(F30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(G30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(H30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(I30,$B$26:$J$26,0)[/TD]
[TD]=MATCH(J30,$B$26:$J$26,0)[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1494"]
<tbody>[TR]
[TD="colspan: 9"]Typed Lookup Array[/TD]
[/TR]
</tbody>[/TABLE]
