What is wrong with the code?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top