Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have two numbers - X and Y.
I want to get value from a sorted list, based on how close Y is to X. Values in the list are let's say from 1 to 5. The values X and Y are between same min/max ranges. Example: X=5 List values: 1,2,3,4,5 Min is 0 Max is 100 If Y=50 the returned value should be 5 If Y=25 or 75, the returned value should be 3 If Y=10 or 90, the returned value should be 1 and so on. any ideas how to emplement? thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Retrieving value from list based on dynamic condition | Excel Discussion (Misc queries) | |||
Filter the results of a list based on a previous vlookup against the same list | Excel Worksheet Functions | |||
Return a price based on a customer from a drop down list | Excel Discussion (Misc queries) | |||
return a list | Excel Worksheet Functions | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) |