I want to determine between which values, in colB, cell A1 falls and report the higher end of the range from colB. So, say A1=789 and col B is the array of numbers below. I would like a function that returns 999.
I thought I could use a nested vlookup with a range lookup of TRUE but that forces the return of the lower value in the range, not the higher. Maybe MAX? Stumped.
299
399
549
749
999
1299
1499
1749
1999
2499
2999
3499
I thought I could use a nested vlookup with a range lookup of TRUE but that forces the return of the lower value in the range, not the higher. Maybe MAX? Stumped.
299
399
549
749
999
1299
1499
1749
1999
2499
2999
3499