| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with MATCH function
In Excel 2007 I am using the MATCH function and trying to return the next
greatest value. For some reason, entering -1 as the match type is returning a #N/A error. I tried a very simple example and it is still returning the same error. In cells A1:A10 I have the values 1 through 10 (in ascending order). In cell B1 I have: =MATCH(5.7,A1:A10,-1). I would think this should return 6 because it rounds up to 6 which is in the sixth row of the array. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with MATCH () function . . . | Excel Worksheet Functions | |||
| Problem with using match function | Excel Worksheet Functions | |||
| Match function problem | Excel Worksheet Functions | |||
| MATCH function problem | Excel Discussion (Misc queries) | |||
| Problem with match function | Excel Discussion (Misc queries) | |||
Threaded Mode
