View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
icemouse
 
Posts: n/a
Default Lookup "greater than or equal to" in lookup array

This is my first post to the discussion group, so hi all.

I'd like to be able to use a vlookup to return a value where the first
column of the lookup array is "greater than or equal" to the value of the
lookup cell. Using TRUE, of course, returns a "less than or equal to" value.
Does anyone know if there is something similar for "grater than"?

Thanks

Phil