LOOKUP the number higher not lower
Assuming the lookup value will not be greater than the max value in your
lookup table.
Try this array formula** :
A2:B15 = lookup table
D2 = lookup value
=INDEX(B2:B15,MATCH(MIN(IF(A2:A15=D2,A2:A15)),A2: A15,0))
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.
--
Biff
Microsoft Excel MVP
"Ivan" wrote in message
...
I have a problem I'm trying to put together a spreadsheet and need the
lookup
command, the lookup command is designed to look at the numbers in the
table
and find the one that is the same or the next one down from what you are
looking for. What I need is to get it to look up the same number or the
next
number up from the one Im looking for. Can someone help me on how to get
that
done.
Thanks In Advance.
|