Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup, next value
Hi,
I am doing a vertical seach in a matrix. Let's say: 1 10 2 20 3 30 4 40 If I enter =Vlookup(2.5;matrix;2) I obtain 20. However, I would like to have the next value, 30 ! I have seach a lot and I have tried formulas like "Cells" but nothing worked. How can i do that? Thank you very much, Alex |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup, next value
Alexandre, try this out:
=VLOOKUP(ROUNDUP(2.5,0),matrix,2) The ROUNDUP() function rounds the number up to basically 3 and thus matches the 30 you are looking for. Cheers, Socratis "Alexandre Campeau" wrote: Hi, I am doing a vertical seach in a matrix. Let's say: 1 10 2 20 3 30 4 40 If I enter =Vlookup(2.5;matrix;2) I obtain 20. However, I would like to have the next value, 30 ! I have seach a lot and I have tried formulas like "Cells" but nothing worked. How can i do that? Thank you very much, Alex |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup, next value
Alex You might want to create a "helper" cell. If say your value 2.5 is in cell A1, in B1 enter the formula = Round(A1, 0 ) The Round function will round 2.5 to 3 and 2.4 to 2. Otherwise use the Roundup function which will round any number from 2..01 and 2.99 to 3 then Use the value in B1 in your Vlookup formula Hope this helps |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |