| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check the interval of a cell withni a range of values
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check for FALSE values in a range of cells in VBA | Excel Discussion (Misc queries) | |||
| Check if rounded cell values fall within a range | Excel Discussion (Misc queries) | |||
| Name Findout From a interval range | Excel Worksheet Functions | |||
| Q: check a range values | Excel Discussion (Misc queries) | |||
| counting values within given interval - countif? | Excel Discussion (Misc queries) | |||
Linear Mode
