Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Function
is there a way to have a Vlookup function return the next largest value if an
exact match is not found? Currently, it will only return the greatest value equal to or less than the value? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP Function
Can you give an example? To me 'next largest value' and 'greatest value equal
to or less than' mean the same. There is no way to change the behaviour of VLOOKUP unless you write your own verision in VBA... "ashoulds" wrote: is there a way to have a Vlookup function return the next largest value if an exact match is not found? Currently, it will only return the greatest value equal to or less than the value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Embedded VLOOKUP function within IF function | Excel Worksheet Functions | |||
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions |