Summary Report

[Steve 1962]

Hi
I am attempting to summarize a team’s play report. Columns A, B & C is the playing program (Week No. / Team location (away or home)).

I require this to be summarized in Columns E to H specifically, column F to show which team the team noted in cell F1 played in the nominated round shown in column E and also its location HOME if located in column B or AWAY if located in column C. Cells F2 to G5 require the solution formula. In this example, Team – 2 is being analysed (cell F1).

Column H is nothing – I have just provided it to show the rows from which the data need to be extracted.

Thanks

Book1
	A	B	C	D	E	F	G	H
1	Week	Home - Team	Away - Team		Week	Team - 2	Location	Comments
2	1	Team - 1	Team - 2		1	Team - 1	Away	(row 2)
3	1	Team - 3	Team - 4		2	Team - 7	Home	(row 6)
4	1	Team - 5	Team - 6		3	Team - 3	Away	(row 11)
5	1	Team - 7	Team - 8		4	Team - 5	Home	(row 16)
6	2	Team - 2	Team - 7
7	2	Team - 3	Team - 4
8	2	Team - 5	Team - 6
9	2	Team - 8	Team - 1
10	3	Team - 1	Team - 4
11	3	Team - 3	Team - 2
12	3	Team - 5	Team - 7
13	3	Team - 6	Team - 8
14	4	Team - 8	Team - 7
15	4	Team - 6	Team - 4
16	4	Team - 2	Team - 5
17	4	Team - 3	Team - 1
Sheet1

 

[Steve 1962]

Thank you very much Bebo. Have a nice week.