Data finding and an associated data range posting elsewhere in the same worksheet

Task 1 These two teams here are a forthcoming fixture, I´d like to search the range (Range A78:L2000) to find every time they have played each other and then in the columns R to V enter the data for each previous meeting of data home team home team score away team score Away team. Note I require all instances for Ravenna v Valentia and Valentia v Ravenna Task 2 In Range W4:Y6 I require the last three times that Ravenna have played at home (Range A78:L2000) , all i require is the same row data from Col L "Std Dev" and the Data from Col N. In Range W7:Y9 I require the last three time that Ravenna have played away from home, again all i require is the data from Col L "Std dev" and the Data from Col M. I would like the above repeating for Valentia in the ranges W10:Y12 and W13:Y15. Please not that the Range A78:L2000 is in date order, oldest first and that the data I require will be at the bottom of the range (some of which is unpopulated at the moment but won´t always be)