What is wrong with the code?

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
 
P

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
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top