On my worksheet column I contains dates, E contains my values and D9 is my
startdate.

=MAX(IF(($I:$I=Shares!$D$9),$E:$E))

What I want to do is find the Max E value where the date (I) is greater than
D9.

I havnt got this quite right yet.

Bruce