Looking fro right LOOKUP formula. Who is the formula expert???

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a list of values NOT in ascending or descending order. I am
looking for a formula that looks for the first cell in the list above
that has a value that is the same or higher than the look-up value.
I use it for the following: I have a list of share values per week
(Column A: Date; Column B: Value). In column C I want the date in the
past that was equal or just lower than the today's value ("The last
time the share price was so high was on 12 March 2003!!!"). I can't
come up with a smart formula that would do the job. The Lookup formula
looks from the top down, if I'm well informed. I need a formula that
looks from the bottom UP!
Help.
Wim

.

Relevant Pages

  • Re: how to switch document list from zyx to abc order?
    ... Double clicking on the column header for 'Name' should reverse the direction. ... Upon opening "my documents" I discovered the file list reversed from ... ascending to descending order. ...
    (microsoft.public.word.docmanagement)
  • Re: integers into strings
    ... no im not converting the inputted number into a string im sorting the ... digits of the value into ascending and descending order and then making ...
    (comp.lang.ada)
  • Re: How can I sort a list of numbers by the last 4 digits?
    ... One method is to insert a dummy column with formula =right ... Then use the sort function to sort the dummy column in ascending or ... descending order. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Stupid Newsreader Question
    ... That unthreads everything then just click on the Sent column to sort by date ... in ascending or descending order. ...
    (rec.pets.dogs.behavior)
  • Re: integers into strings
    ... seperate the digits then arrange it in ascending and descending order and subtract and ascending number from the descending number ... Jeff Carter "My name is Jim, but most people call me ... ...
    (comp.lang.ada)