Hello, people...

I'm having a heck of a time devising a formula for a seemingly simple
task, which I will outline below:

I've got a page in my workbook named "Schedules". On this page, B1:IU1
is a series of dates...specifically, dates on which a college football
game may be played. A list of college football teams is alphabetically
entered in cells A3:A149. I have entered the OPPONENT for each team in
the column corresponding to the date that the game will be played.

Example:

Cell A3 = "Air Force"
Cell Q1 = "September 9" ---(This is the date of Air Force's first
game)
Cell Q3 = "Tennessee" ---(Air Force's first opponent)

Now, here's what I'm trying to do:

I have a seperate page in my workbook for each team. The page named
"Air Force" has the team name (Air Force) entered into cell A1. On
each team page, there is a table for that team's schedule. What I want
to do, is write a formula that will MATCH the value in cell A1 (Air
Force), with the list of teams in Schedules!A3:A149. Then, look across
that row for the FIRST column with data...which, in the example, above,
would be column Q. The value in the FIRST column with data should then
be returned to the first space in the table for that particular team's
schedule. In the example...the first space on the schedule for Air
Force would show the value "Tennessee".

Then, I want to drop down one cell, and in that cell return the value
for the SECOND cell in a row that contains data. And so on....

This way, I can enter the entire season's schedule on the "Schedules"
page, and the schedules on each individual team page will be entered
automatically.

If this makes any sense at all, give me some idea of a formula that
might accomplish this. I have tried numerous combinations of MATCH,
VLOOKUP, HLOOKUP, INDEX,....and God-knows-what-else. :(

Point me in the right direction, please. :)

Thanks, in advance, for any help you can give me, here.


--
HuskerBronco
------------------------------------------------------------------------
HuskerBronco's Profile: http://www.excelforum.com/member.php...fo&userid=4803
View this thread: http://www.excelforum.com/showthread...hreadid=573560