Help with lookup/search formula

[SP]

Hi,

I am looking for a formula that will solve the following problem:

Going off the feb 14th value (61.68) in the close column, I want to find the first number in the high column (starting with feb 19th) that is greater than the close value of feb 14th.

Obviously the answer is 63.50 on march 4th.

How would I write a formula for this function? Thank you.


Date Open High Low Close
14-Feb-02 62.00 62.99 61.32 61.68
15-Feb-02 61.70 62.06 60.20 60.23
19-Feb-02 59.91 60.14 58.60 58.93
20-Feb-02 59.40 60.36 58.80 59.90
21-Feb-02 59.72 60.27 58.01 58.05
22-Feb-02 58.05 58.75 57.15 57.99
25-Feb-02 57.94 59.89 57.89 59.08
26-Feb-02 59.10 60.00 57.90 58.55
27-Feb-02 59.07 60.15 57.99 58.39
28-Feb-02 58.78 59.70 58.14 58.34
1-Mar-02 59.05 61.42 58.85 61.37
4-Mar-02 61.24 63.50 60.87 63.30

 

[tactps]

Assume that 14-Feb value you are looking for is in cell E2 and the column you want to look at is column C:
=OFFSET(C2,MATCH(VLOOKUP(E2,C4:C13,1),C2:C13),0)

 

[SP]

Thanks!!!