Dynamic Lookup / Index Match

Hi everyone,

A question for you. It might be best to just lay out the issue.

I have a column, A, with dates in chronological, ascending order. For the sake of argument, lets say column A starts from Jan 2009 and ends at today. In column B, I have prices. Column B may have duplicates.

Now, lets say in column E I have a date of March 3, 2009, and in column F I have a price of $4.34 (doesn't really matter what it is for the sake of argument). What I want to do is, determine the NEXT date from column A is that has the corresponding price that is greater than or equal to $4.34 AFTER March 3, 2009. But if we do a VLOOKUP, I would like it to be dynamic, such that, it always uses the same column E and F. This is because I will have other dates and prices in columsn E and F where I'd like to just copy paste the formula downwards.

If that isn't clear enough, please let me know!

Thanks,
Mrgreek

Hi Mrgreek,

Here's my take... it involves arrays... so after you edit cell H3, you must use an array-enter (CTRL-SHIFT-ENTER), instead of just ENTER.

Let me know if you have any questions.

Dennis

worked like a charm, thank you kind sir