E
Eric
There is a list of value under AI column
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14
There is a list of value under AL column
0.7, 0.9, 0.3, 0.5, 0.4, 0.6, 1.5, 0.8, 1.0, 0.2, 1.3, 1.1, 1.6, 1.4
=INDEX(AI:AI,MATCH(1.3,AL:AL,0)), which return 11 in cell AP1, but
=INDEX(AI:AI,MATCH(1.1,AL:AL,0)), which return #N/A in cell AQ1 and it
should return 12 in AQ1.
Does anyone have any suggestions on what wrong is the code?
Thanks in advance for any suggestions
Eric
1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14
There is a list of value under AL column
0.7, 0.9, 0.3, 0.5, 0.4, 0.6, 1.5, 0.8, 1.0, 0.2, 1.3, 1.1, 1.6, 1.4
=INDEX(AI:AI,MATCH(1.3,AL:AL,0)), which return 11 in cell AP1, but
=INDEX(AI:AI,MATCH(1.1,AL:AL,0)), which return #N/A in cell AQ1 and it
should return 12 in AQ1.
Does anyone have any suggestions on what wrong is the code?
Thanks in advance for any suggestions
Eric