Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I don't know if this will be a vlookup or something similar but here's what I
need: -user enters a number that could range anywhere from 0 to 22667.27 -formula should match whatever number the user entered against an applicable range and then return a different number -For example a user enters 2931.15 -Formula should return a value of "125" since the user defined number falls between 2930.92 and 2954.54 -Formula should return a value of "126" if user enters 2970.12 because that value falls between 2954.55 and 2978.18 I have a list of hundreds of different ranges like this going from 0 all the way to 22667.27. Please help! Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Last Date Modified | Excel Worksheet Functions | |||
Last Modified by... | Excel Discussion (Misc queries) | |||
Last Modified | Excel Worksheet Functions | |||
Modified files | Excel Discussion (Misc queries) | |||
Modified Duration | Excel Worksheet Functions |