Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help. Trying to do the opposite of VLOOKUP
I have a specific number X in a cell and in the column beside I have a list of data that ranges from smalles to largest. I need to find a number in that column the is = or than X. the number should be the closest number to X but greater.
Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help. Trying to do the opposite of VLOOKUP
Il 09/11/2012 06:36, Randy Sauve ha scritto:
I have a specific number X in a cell and in the column beside I have a list of data that ranges from smalles to largest. I need to find a number in that column the is = or than X. the number should be the closest number to X but greater. Any ideas? The number to find is in A1, rng is the list: =INDEX(rng,IF(MATCH(A1,rng)=MATCH(A1,rng,0),MATCH( A1,rng),MATCH(A1,rng)+1)) Hi, E. |
#3
|
|||
|
|||
Quote:
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help. Trying to do the opposite of VLOOKUP
Il 09/11/2012 16:29, Randy Sauve ha scritto:
plinius;1607245 Wrote: Il 09/11/2012 06:36, Randy Sauve ha scritto:- I have a specific number X in a cell and in the column beside I have a list of data that ranges from smalles to largest. I need to find a number in that column the is = or than X. the number should be the closest number to X but greater. Any ideas? - The number to find is in A1, rng is the list: =INDEX(rng,IF(MATCH(A1,rng)=MATCH(A1,rng,0),MATCH( A1,rng),MATCH(A1,rng)+1)) Hi, E. The only problem with this is that if the closest number to A1 is greater than 1+A1 than I get an error. I don't understand what error occours. That formula get the number x (the number in A1) if it exists in rng. If it does not exist, formula get the number immediately greater then x present in rng. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opposite direction | Excel Worksheet Functions | |||
Opposite of Vlookup | Excel Discussion (Misc queries) | |||
opposite of vlookup function? | Excel Discussion (Misc queries) | |||
Now I want the opposite | Excel Programming | |||
The opposite of IF function gives #VALUE for value = 0 | Excel Worksheet Functions |