View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ashoulds ashoulds is offline
external usenet poster
 
Posts: 7
Default 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?