| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to code the formula?
Does anyone have any suggestions on how to code the formula within Excel?
There is a list of values under M2:M27 in descending order with space in between, and show below M N 1871 1866 1849 1830 1830 1825 1786 1781 1658 1657 1641 1641 1630 There is a given number 1780 in cell C37, I would like to determine the matched value under N column, and return it into F37, which find the max. number under column M and this number is less than the given number 1780, the matched number should be 1658 under column M, and 1657 under column N should be returned into cell F37. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula, code or macro? | Excel Discussion (Misc queries) | |||
| formula or vba code | Excel Worksheet Functions | |||
| formula code | Excel Discussion (Misc queries) | |||
| formula / code help needed | Excel Discussion (Misc queries) | |||
| formula or code | Excel Worksheet Functions | |||
Threaded Mode
