Lookup with Excel 2003

I have a spreadsheet history of stock prices in column D231502. The dates are in column A23:A1502.

The HIGH value of the stock is listed in cell D18.

I would like to also show the DATE corresponding to the HIGH.

I have a second set of stock prices in F23:F1502, with that HIGH in F18.

I have stumbled along and come up with the following, which does not work!

=OFFSET(D22(MATCH(D18, D231502),0)-0,0,0))

Can anyone point me in the correct direction?

Thanks, Larry

 

Larry, I don't know about the formula, but it looks like you have one too many brackets at the end:

Should look like: =OFFSET(D22(MATCH(D18, D231502),0)-0,0,0)

Code:

=OFFSET(D22(MATCH(D18, D23:D1502),0)-0,0,0)

????

Oops the BBS put a smilie in the middle, just ignore!!!

edit note: John, just use a set of code tags when that happens to give a clean display. I did it for you here. Newt

 

Lookup in Excel 2003

Nope, that's not it, The correct formula is:
=INDEX($A$23:$A$1502, MATCH(D$18, D$23$1502, 0))

Got the answer from the Mr. Excel BBS but thanks for your time!