Index match with multiple criteria

[zeppidoo]

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

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

 

[oldbrewer]

you have 6 data fields and 9 columns ?

 

[zeppidoo]

Sorry the first 3 fields should be blank the 300 should be over the 175.89

 

[oldbrewer]

			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
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
so this is your data - are the first 3 columns parts of a zip code ?
what is the 72316 in 4th column 18th row ?

<colgroup><col span="10"></colgroup><tbody>
</tbody>

 

[zeppidoo]

Ahhhhh, Well you fixed it! I didnt even notice but column 3 is wrong it should say 85 and not 9000. when corrected this fixed my issue. Thanks for pointing it out

 

[oldbrewer]

It was nothing - literally !