What is wrong with the code?
 

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

What is wrong with the code?
 

Are you sure that the 1.1 in AL12 is really 1.1? Increase the number
of decimals to check - it might be 1.1000001 if it is the result of a
calculation, in which case MATCH will not see it as being the same as
1.1. You can use ROUND(your_calc,1) in column AL to ensure it is only
1 dp.

Hope this helps.

Pete

On Sep 13, 10:22 am, Eric wrote:
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

What is wrong with the code?
 

Eric

It will return 12 if your data in column AL are correct I'd delete the cell
contents that contain 1.1 check the formatting and then re-enter 1.1

Mike

"Eric" wrote:

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