Return value in table associated with next greatest
I have a table of Data:
HP COST
3 $250
5 $400
7.5 $450
10 $500
15 $650
20 $750
25 $800
User Enters 7.2
I need to return the cost associated with the next greatest HP (7.5), or $450. I know VLOOKUP would return the next less, or $400.
|