When using VLOOKUP, the lookup value is compared to the first column. If
there is no exact match, it returns the closest match that is LOWER than the
lookup value. Is there a way that I can specify it returns the closest match
that is HIGHER than the lookup value?

Part of my worksheet has a series of engine sizes in the left hand column.
According to user input of their vehicle's engine size, the lookup should
return a value accordingly. My current list of sizes is entered as:
(up to)
2000, 2500, 3000, etc.

Naturally with engines, they range greatly in size and if my engine is (for
example) 2200cc, I want to return a value from the 2000 to 2500 row (simply
listed in my sheet as '2500') This would require Vlookup to return the next
higher value.

Thanks in advance for any help.