Hello,
I am trying to run an Index match formula with a zip code plus class number and the formula I am using returns a value that doesnt match.
=INDEX('Outbound Rates'!$CI$3:$CN$3263,MATCH($CK$13&$CM$55,INDEX('Outbound Rates'!$CF$3:$CF$3263&'Outbound Rates'!$CH$3:$CH$3263,),1),MATCH($CY55,'Outbound Rates'!$CI$2:$CN$2,0)),""),"")
Ck13=08753
CM55=85
Data field= 300 500 1000 5000 10000 15000
<colgroup><col width="64" style="width:48pt"> <col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
Further down in the same field is the following zip which is the value that is returned instead of the value from the first field. I believe it has something to do with the zip begins with a zero.
<colgroup><col width="64" style="width:48pt"> <col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
Please help
I am trying to run an Index match formula with a zip code plus class number and the formula I am using returns a value that doesnt match.
=INDEX('Outbound Rates'!$CI$3:$CN$3263,MATCH($CK$13&$CM$55,INDEX('Outbound Rates'!$CF$3:$CF$3263&'Outbound Rates'!$CH$3:$CH$3263,),1),MATCH($CY55,'Outbound Rates'!$CI$2:$CN$2,0)),""),"")
Ck13=08753
CM55=85
Data field= 300 500 1000 5000 10000 15000
7999 | 80 | 85 | 175.89 | 135.58 | 100.34 | 79.33 | 52.82 | 44.77 |
7999 | 80 | 175 | 360.57 | 277.92 | 205.67 | 162.61 | 112.71 | 95.52 |
8199 | 80 | 85 | 205.3 | 159.75 | 120.96 | 98.85 | 72 | 60.86 |
8199 | 80 | 175 | 420.83 | 327.47 | 247.96 | 202.62 | 153.62 | 129.83 |
8299 | 80 | 85 | 214.38 | 166.88 | 126.83 | 103.98 | 77.52 | 65.79 |
8299 | 80 | 175 | 439.47 | 342.09 | 259.99 | 213.14 | 165.38 | 140.35 |
8399 | 80 | 85 | 212.54 | 165.38 | 125.9 | 103.01 | 76.44 | 64.64 |
8399 | 80 | 175 | 435.68 | 339.02 | 258.08 | 211.16 | 163.09 | 137.92 |
8499 | 80 | 85 | 214.38 | 166.88 | 126.83 | 103.98 | 77.52 | 65.79 |
8499 | 80 | 175 | 439.47 | 342.09 | 259.99 | 213.14 | 165.38 | 140.35 |
8699 | 80 | 85 | 196.7 | 153.17 | 115.28 | 92.85 | 66.26 | 56.09 |
8699 | 80 | 175 | 403.21 | 313.99 | 236.32 | 190.33 | 141.38 | 119.66 |
8799 | 80 | 85 | 198.51 | 154.31 | 116.63 | 93.9 | 67.55 | 57.06 |
8799 | 80 | 175 | 406.94 | 316.32 | 239.06 | 192.49 | 144.13 | 121.73 |
<colgroup><col width="64" style="width:48pt"> <col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
Further down in the same field is the following zip which is the value that is returned instead of the value from the first field. I believe it has something to do with the zip begins with a zero.
87375 | 600 | 9000 | 74994 | 40410 | 34353 | 28787 | 23811 | 21550 |
87499 | 600 | 9000 | 74236 | 39826 | 33812 | 28289 | 23368 | 21096 |
87509 | 600 | 9000 | 72316 | 38372 | 32455 | 27046 | 22244 | 19950 |
87587 | 600 | 9000 | 83163 | 44128 | 37324 | 31103 | 25581 | 22943 |
87522 | 600 | 9000 | 126553 | 67151 | 56797 | 47331 | 38927 | 34913 |
<colgroup><col width="64" style="width:48pt"> <col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
Please help