Vlookup or Hlookup defaults to the number before your search value. Not sure
about finding the number above yoru search value.

"lepche" wrote:

I'm trying to match the lookup value with the number closest (larger or
smaller) than the value. Can this be done?