Find the Max Date in a list depending on a Cell Value

I'd like to find the Max. Date Value depending on a cell value.
In attached file explained what is wanted.

Thanks in advance for any reply and help.

Regards,
turist.

Originally Posted by XOR LX

Hi again,

=MAX(INDEX((Sheet2!$A$2:$A$21<=Sheet1!$F$1)*Sheet2!$A$2:$A$21,,))

Regards

Thanks again.

Works, great.