# Help with lookup/search formula

#### SP

##### New Member
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

### Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
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)

Thanks!!!

Replies
5
Views
891

1,221,124
Messages
6,158,070
Members
451,463
Latest member
PowerIon2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back