Help with Sorting I guess???

[zendog1960]

Here is what I would like to do. I play in a softball league which plays 7 weeks per season. Each Week we play a doubleheader. I want to create team specific stats thus standings but having trouble figuring out how to make the following example work:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	Visitors	Home	Score		*	*	Perini	Runs For	Runs Against	Win	Loss
2	Base Knocks	Perini	5	7	*	*	Week 1 G1	*	*	*	*
3	Perini	Base Knocks	12	18	*	*	Week 1 G2	*	*	*	*
4	MGM Mirage	Tough Times	13	8	*	*	*	*	*	*	*
5	Tough Times	MGM Mirage	22	5	*	*	*	*	*	*	*
Sheet4

The worksheet shows the first week of the schedule. As shown the team Perini was the home team the first game of the double header then the visitor in the second game. I could make a direct reference to the cell D2 for H2 but that isn't always the case as Perini next week might be Visitors first. Having said that I guess I need some kind of Look up function to first find out if Perini is the Home or Visitor for the first game them copy the appropriate score to the teams stat columns in the range H2:I3.

When finished, the Team Stat Area Should Look Like this:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	Visitors	Home	Score		*	*	Perini	Runs For	Runs Against	Win	Loss
2	Base Knocks	Perini	5	7	*	*	Week 1 G1	7	5	X	*
3	Perini	Base Knocks	12	18	*	*	Week 1 G2	12	18	*	X
4	MGM Mirage	Tough Times	13	8	*	*	*	*	*	*	*
5	Tough Times	MGM Mirage	22	5	*	*	*	*	*	*	*
Sheet4

Any and all help with this would be greatly apprciated. I have pulled more hair out than I am able to grow back on this so herry before I go bald! LOL

Thanks

 

[zendog1960]

bump??

 

[zendog1960]

Any thoughts on this problem? I have tried searching for some answers on this site but have failed to come up with any solutions....