View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Craig Craig is offline
external usenet poster
 
Posts: 208
Default Vlookup Approximate Match Question

Hi...

In the Vlookup approximate match situation, (range lookup argument is true)
the function returns a value on the same row to the closest matching value in
a lookup table that is less than or equal to the lookup value...is there
anyway to change it so it returns a value on the same row to the closest
matching value in to the lookup value even though the closest value may be
higher than the lookup value?
thank you!

Craig