Find most recent data entry and input values in that row

[Jzfbkr]

I'm looking to find the 5 last data entries that meet a criteria. In this case its the name of a team.

So when the team name is: TEAM A

Return the last 5 fixture dates and corresponding information. DATA,FIXTURE,SCORELINE

My table is presented as such:


[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Fixture[/TD]
[TD]Team[/TD]
[TD]Home Score[/TD]
[TD]Away Score[/TD]
[/TR]
[TR]
[TD]13/09/2014[/TD]
[TD]TEAM A V TEAM B[/TD]
[TD]TEAM A[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]13/09/2014[/TD]
[TD]TEAM A V TEAM B[/TD]
[TD]TEAM B[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]20/09/2014[/TD]
[TD]TEAM C V TEAM A[/TD]
[TD]TEAM C[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]20/09/2014[/TD]
[TD]TEAM C V TEAM A[/TD]
[TD]TEAM A[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]









with in the given example the formula must recognise the 5 most recent dates and return the date, fixture, scoreline and teams for each.

Any help on this would be massively appreciated