Filter a league's schedule down to one team's game for that week

[robgoldstein]

Hey All,
I am trying to figure out how to filter a league's schedule down to one team's schedule for a specific date and then be able to pull that information in some other cells to fill in the game sheet.
I would need to filter by club, then division then team then date so I end up with a single row of information. The team name could be in the home team column or the away team column.

Any thoughts would be appreciated.

 

[asjmoron]

do you have an example of the sheet you are using?

 

[robgoldstein]

I do.

Is there a way to upload the file or can I only upload a screen capture of it?

I have uploaded a screen capture of the schedule sheet and the worksheet where I need to get the information into, by selecting the date and team.