I have a schedule of 16 teams over 17 weeks. Right now the weeks are in rows
and matches are in columns, i.e.
A B C D E
1 01/31 01 - 02 03 - 04 05 - 06 07 - 08
2 02/07 04 - 01 06 - 03 08 - 08 10 - 07
3 02/14 05 - 14 09 - 02 12 - 04 16 - 13

Therefore, cell B2 states on Feb. 7th, Team 4 plays against Team 1. Since
one cell contains two numbers, is there a formula that will for one of the
two numbers and return the entire cell to another worksheet? So I can pull
all of one Team's schedule onto a separate worksheet and into one column,
putting formula in column B?
A B
1 01/31 03 - 04
2 02/7 06 - 03
3 02/14 03 - 08
4 02/21 10 - 03

Hope this makes sense, and Thanks a Bunch in advance

T