Using the right formula to MATCH/INDEX/VLOOKUP cells that follow a specific condition

Please see the attachment.

On sheet Data I have a list of soccer matches (A:B) played on various dates (C:C) with results (D:E) and statistics (F:G) plus some counter columns (H:I) highlighting the most recently completed matches.

On sheet Preview I would like to separate this data as shown on the attachment, into home and away team previews.
In this example, I would like to compare Nines vs Kangas,
By writing "Nines" into cell A2 I would like to put the correct formulas into A4:G9 to complete the data as shown in the attachment. This will show the most recently played match (defined by when there is a score inserted in Data!D:E) involving Nines on the top line, and then the rest of the results below in chronological order, regardless of whether they play at home or away.

In order to achieve this, do I need to have a series of looks ups? Do I need to have a further counting column on the Data page that counts either??


Thanks,
Marco

Do you want ALL games or only the last 6 (or "n" games)?

"n" games would be best

Outstanding, thank you very much JohnTopley

Used 2 helper columns;

in J

=IF(OR($A2=Preview!$A$2,$B2=Preview!$A$2),"H","")

in K

=IF(OR($A2=Preview!$A$17,$B2=Preview!$A$17),"A","")

in Preview

in A19

=IFERROR(INDEX(Data!A$2:A$300,LARGE(IF((Data!$K$2:$K$300="A")*(Data!$D$2:$D$300<>""),ROW(Data!$A$2:$A$300)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

Enter as before

I would put the AWAY table alongside the home (say column J)

Splendid.
Thanks