| 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 |
| 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 | |||
Threaded Mode
