Hey,

I have an if formulae that rounds a value depending on the range it falls between. Its very long and messy and i would like to have the capability of changing the table so i think a vlookup would be best suited. is it possible to run a vlookup without an exact match i.e. values in a given range?

If 15 < qty < 100, round up to nearest 5.
If 100 < qty < 300, round up to nearest 10
If 300 < qty < 500, round up to nearest 50
If qty > 500, round up to nearest 100.

Thanks,

Adam