View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ashoulds ashoulds is offline
external usenet poster
 
Posts: 7
Default VLOOKUP FUNCTION

Is there a way to return the next largest value using a vlookup function when
an exact match is not found? As of now, it keeps returning the value that
matches or the next smallest value.