Check the interval of a cell withni a range of values
where the value to look up is in C1, you could try:
=VLOOKUP(C1,A1:B4,2,TRUE)
"dakke" wrote:
Suppose the following table:
**********
* A * B *
************
************
1 ** 1 * B1 *
2 ** 5 * B2 *
3 ** 8 * B3 *
4 ** 20 * B4 *
***********
and a cell with number 4.
I would like to get B1 displayed, since the number 4 is bigger than A1
(namely '1', but smaller than A2 ('5'). Is this possible using functions?
|