Land_Shark918
New Member
- Joined
- Dec 30, 2016
- Messages
- 13
I am trying to have excel find the largest "Cost" value in a given range that is lower than a specified Cost value. I then need it to display its corresponding "Ton" value. Problem is that i need it to look the value up in reverse order, in order o have it select the absolute lares value in the entire table. I've looked all over, and seen multiple "solutions", but haven't had one work yet. See below for reference
Nick
<tbody>
</tbody>
Nick
$ 250,000.00 | <<need to="" find="" the="" next="" value="" lower="" than="" this="" in="" entire="" range<="" td=""></need> | |||
Ton | Cost | |||
N/A | N/A | |||
N/A | N/A | |||
N/A | N/A | |||
N/A | N/A | |||
N/A | N/A | |||
N/A | N/A | |||
N/A | N/A | |||
100 | $ 17,396 | |||
294 | $ 51,184 | |||
488 | $ 84,971 | |||
682 | $ 118,759 | |||
875 | $ 152,547 | |||
1,069 | $ 186,334 | |||
1,263 | $ 220,122 | |||
1,457 | $ 253,910 | |||
1,651 | $ 287,697 | |||
1,845 | $ 321,485 | |||
2,039 | $ 228,129 | |||
2,233 | $ 249,825 | |||
2,427 | $ 271,520 | |||
2,621 | $ 293,216 | |||
2,814 | $ 314,912 | |||
3,008 | $ 336,608 | |||
3,202 | $ 358,304 | |||
3,396 | $ 380,000 | |||
3,590 | $ 401,695 | |||
3,784 | $ 423,391 | |||
3,978 | $ 445,087 | |||
4,172 | $ 357,899 | |||
4,366 | $ 374,534 | |||
4,560 | $ 391,169 | |||
4,754 | $ 407,804 | |||
4,947 | $ 424,439 | |||
5,141 | $ 441,074 | |||
5,335 | $ 457,709 | |||
5,529 | $ 474,344 | |||
5,723 | $ 490,979 | |||
5,917 | $ 507,613 | |||
6,111 | $ 436,741 | |||
6,305 | $ 450,600 | |||
6,499 | $ 464,458 |
<tbody>
</tbody>