INDEX with conditions

Hi

I'm getting a bit mixed up with my conditions whilst indexing.

I have enclosed the sample data. Basically my indexing function is working on sheet2 to pull the date from a list of orders into a client matrix. I was hoping to add a condition of "=Y" from the column D (Repeat Order) on the Orders sheet.

I have tried various combinations and am now loseing my way (and my hair). Can anyone help?