I am using LOOKUP and VLOOKUP to lookup data on tables. I have done this
successfully, but I get unusual results when looking up calculated values.
Sometimes the lookup results are correct sometimes not. All values are
numbers, lookup_vector is in descending order. Lookup works when value is
typed in cell not calculated. Unfortunately I need to lookup the value
calculated from a lookup value. calculation is simple ie =D2+0.1

I am specifically looking up the values less than and greater than the
lookup_value. I have been looking up the less than value then adding 0.1 to
get the greater than value.