View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.