|Subject:||Looking fro right LOOKUP formula. Who is the formula expert???|
|Posted by:||Wim (firstname.lastname@example.org)|
|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!