Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Add chart - what is wrong with the code? | Charts and Charting in Excel | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) | |||
Can someone tell me what is wrong with this code? | Excel Discussion (Misc queries) | |||
What's wrong with my code ? | Excel Worksheet Functions |