Thread: lookup tables
View Single Post
  #1   Report Post  
Richard D
 
Posts: n/a
Default lookup tables

If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value.

I want to find the next LARGEST value in a table that I have sorted. Is this
possible?