Hi DBY,

Thanks for your help, that formula works great.

I tried doing similar for MIN instead of MAX using the following formula however it's returning a value of 0.000:

=MIN((MONTH(Pricing_Date)=MONTH(A6))*(YEAR(Pricing_Date)=YEAR(A6))*Day_Low_Price)

i.e.

=MIN((MONTH(I4:I269)=MONTH(A6))*(YEAR(I4:I269)=YEAR(A6))*L4:L269)

which I entered in as an array formula.

Would this formula work for MIN, or am I doing something wrong?

Thanks again, much appreciated