- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- Looking fro right LOOKUP formula. Who is the formula expert???

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

- Re: Looking fro right LOOKUP formula. Who is the formula expert??? posted by T. Valko on Wed, 31 Jan 2007