| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
return a value from a range
Hi all,
I have a column of numbers in D3:D25 and corresponding values in E3:E25. When I enter a value into A3, I would like B3 to return the value that corresponds to column D where it's value is NOT higher than A3. For example: If A3=22.3...and column D numbers are 21.5,22.5,23.5, I would like to return the value next to the cell with the 22.5. Things sure are difficult to explain in text sometimes!!! Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return date if in range, else return blank | Excel Worksheet Functions | |||
| Return Range Address from Active Range | Excel Programming | |||
| return min. of range except 0 | Excel Discussion (Misc queries) | |||
| Return the name of a range | Excel Programming | |||
| How do I return the name of a Range? | Excel Programming | |||
Threaded Mode
