View Single Post
  #1   Report Post  
fuji fuji is offline
Junior Member
 
Posts: 1
Default 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.