Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup Hi / Lo
I'm trying to do what i think is quite a simple function. I have a data array (B5:B13) with the following values in it: 14 40 45 59 70 79 90 100 280 my reference cell is C16 and is currently set to 63. I would like cell C18 to display the closest match below 63 (in this example 59), i have acheived this with the forumula =LOOKUP(C16,B5:B13,B5:B13). But i want cell C19 to display the closest value above 63 i.e. 70. I have tried the offset function but can't appear to get it to work, and would prefer a lookup function if possible. Thanks in advance, Chris -- chrisabberton ------------------------------------------------------------------------ chrisabberton's Profile: http://www.excelforum.com/member.php...o&userid=16872 View this thread: http://www.excelforum.com/showthread...hreadid=474744 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |