| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
Quote:
To output $: =INDEX(B1:B7,MATCH(C1,A1:A7)+1) To output HP: =INDEX(A1:A7,MATCH(C1,A1:A7)+1)
__________________
Asobi Wa Owari Da |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return the greatest value in a range of cells | Excel Discussion (Misc queries) | |||
| greatest value function? | Excel Discussion (Misc queries) | |||
| Finding the greatest value | Excel Discussion (Misc queries) | |||
| Greatest to smallest | Excel Discussion (Misc queries) | |||
| Displaying Greatest to Least? | Excel Discussion (Misc queries) | |||
Linear Mode
