I have several worksheets that are used to input data into to a summary
worksheet for a golf league One of the worksheets is a schedule. The schedule
worksheet has 18 columns (one for each week) and the 32 rows have the team's
tee positions and opponents for that week. When the summary worksheets is
printed each week it has the current weeks schedule shown.

I would like to be able to have the current week's scheduled transfered to
the summary sheet by identifying the week number and have the data transfered
from the schedule worksheet to the summary worksheet. I tried the lookup
function, with the lookup value being the week number and the lookup vector
being the row with week1, week2,..., etc. and the result vector being a cell
in one of the columns. The problem with this is when you change input value
(week number), the lookup result vector does not change.

Any suggestion on how to best do this would be appreciated.

I'm not sure how you're using the table on the schedule worksheet, but I would
think that the first column would be the names of the team, then columns 2
through 19 would be the time for each team.

If that's the case, maybe (with the teamname in A2 and the week number in A1):

=vlookup(a2,sheet2!A:S,$a$1,false)

would be sufficient.

Depending on what your data looks like, you might want to use =index(match()).

You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

for more information.

Larry L wrote:

I have several worksheets that are used to input data into to a summary
worksheet for a golf league One of the worksheets is a schedule. The schedule
worksheet has 18 columns (one for each week) and the 32 rows have the team's
tee positions and opponents for that week. When the summary worksheets is
printed each week it has the current weeks schedule shown.

I would like to be able to have the current week's scheduled transfered to
the summary sheet by identifying the week number and have the data transfered
from the schedule worksheet to the summary worksheet. I tried the lookup
function, with the lookup value being the week number and the lookup vector
being the row with week1, week2,..., etc. and the result vector being a cell
in one of the columns. The problem with this is when you change input value
(week number), the lookup result vector does not change.

Any suggestion on how to best do this would be appreciated.



--

Dave Peterson