What is wrong with the code?

[Guest]

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

 

[Pete_UK]

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

 

[Guest]

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