View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vlookup help pls
 
Posts: n/a
Default need to select closest match using vlookup if it higher or lower

i cant get vlookup to select the closest value if the closest value is higher
it automatically selects the highest value below the cell value