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

Giganews Newsgroups
Subject: Looking fro right LOOKUP formula. Who is the formula expert???
Posted by:  Wim (eisingspam@iafrica.com)
Date: 30 Jan 2007

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

Replies