Need LOOKUP to find the number above not below the specified numbe
 

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.

Need LOOKUP to find the number above not below the specified numbe
 

see your other post

--
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.