software

Hello,

I manage a sports league, and one of my most common tasks is to make
the season schedule at the beginning of the year, where each time has
to play another, at different times of the week. Each team has sent me
a set of availability restrictions, daysamp;times of the week that they
are unable to play. Thus, when I make my schedule, I have to take these
restrictions into account.

I have one separate worksheet for the game *schedule*, and another for
the *restrictions*. Thus in the worksheet quot;schedulequot; I have the home
team under column A, playing versus the away team on column B. In the
worksheet quot;restrictionsquot;, I have the team name under column A, and
their restrictions under column B.

e.g.

_\quot;Schedule\quot;_worksheet_
-Column A / Column B-
Footsies/ MISN Impossible
Money Shot / Rejects
Grrr / McGrads I
Pink Seagulls / Mailmen FC
etc.

_\quot;Restrictions\quot;_worksheet_
-Column A / Column B-
Footsies / no Jan 9,12,16 no Feb 6-8
Money Shot / No Jan 9, No Thursdays
Grrr / no Jan 16
etc.

My question: is there a way in Excel to set up columns C amp; D in the
worksheet quot;schedulequot; such that it returns the restrictions I have set
up in the worksheet quot;restrictionsquot;? (column C for the home team, and
column D for the away team). I basically need a function that goes
through the list in A, matches the team name in the restrictions
worksheet, and then returns the restriction quot;valuequot; (which is in fact,
text) in the quot;schedulequot; worksheet.

I tried the quot;IFquot; function, but it doesn't work. Any help would be
appreciated.--
mpanty
------------------------------------------------------------------------
mpanty's Profile: www.excelforum.com/member.php...oamp;userid=21377
View this thread: www.excelforum.com/showthread...hreadid=501194
No clues? Seems pretty straightforward in theory... I just don't have
sufficient Excel knowledge to know of the right formula...--
mpanty
------------------------------------------------------------------------
mpanty's Profile: www.excelforum.com/member.php...oamp;userid=21377
View this thread: www.excelforum.com/showthread...hreadid=501194use vlookup to look for the team name in the other workshheet and return the
restriction in cols c for col a and d for colb
the lookup formula say in col c1 of sheet quot;schedulequot; looks like this
=vlookup(A1,restrictions!A1:B7,false)
for this to work the team names(spelling wise) have to be identical in both
sheets
--
paul
remove nospam for email addy!
quot;mpantyquot; wrote:

gt;
gt; Hello,
gt;
gt; I manage a sports league, and one of my most common tasks is to make
gt; the season schedule at the beginning of the year, where each time has
gt; to play another, at different times of the week. Each team has sent me
gt; a set of availability restrictions, daysamp;times of the week that they
gt; are unable to play. Thus, when I make my schedule, I have to take these
gt; restrictions into account.
gt;
gt; I have one separate worksheet for the game *schedule*, and another for
gt; the *restrictions*. Thus in the worksheet quot;schedulequot; I have the home
gt; team under column A, playing versus the away team on column B. In the
gt; worksheet quot;restrictionsquot;, I have the team name under column A, and
gt; their restrictions under column B.
gt;
gt; e.g.
gt;
gt; _\quot;Schedule\quot;_worksheet_
gt; -Column A / Column B-
gt; Footsies/ MISN Impossible
gt; Money Shot / Rejects
gt; Grrr / McGrads I
gt; Pink Seagulls / Mailmen FC
gt; etc.
gt;
gt; _\quot;Restrictions\quot;_worksheet_
gt; -Column A / Column B-
gt; Footsies / no Jan 9,12,16 no Feb 6-8
gt; Money Shot / No Jan 9, No Thursdays
gt; Grrr / no Jan 16
gt; etc.
gt;
gt; My question: is there a way in Excel to set up columns C amp; D in the
gt; worksheet quot;schedulequot; such that it returns the restrictions I have set
gt; up in the worksheet quot;restrictionsquot;? (column C for the home team, and
gt; column D for the away team). I basically need a function that goes
gt; through the list in A, matches the team name in the restrictions
gt; worksheet, and then returns the restriction quot;valuequot; (which is in fact,
gt; text) in the quot;schedulequot; worksheet.
gt;
gt; I tried the quot;IFquot; function, but it doesn't work. Any help would be
gt; appreciated.
gt;
gt;
gt; --
gt; mpanty
gt; ------------------------------------------------------------------------
gt; mpanty's Profile: www.excelforum.com/member.php...oamp;userid=21377
gt; View this thread: www.excelforum.com/showthread...hreadid=501194
gt;
gt;

what no response??? :-)
--
paul
remove nospam for email addy!
quot;paulquot; wrote:

gt; use vlookup to look for the team name in the other workshheet and return the
gt; restriction in cols c for col a and d for colb
gt; the lookup formula say in col c1 of sheet quot;schedulequot; looks like this
gt; =vlookup(A1,restrictions!A1:B7,false)
gt; for this to work the team names(spelling wise) have to be identical in both
gt; sheets
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;
gt; quot;mpantyquot; wrote:
gt;
gt; gt;
gt; gt; Hello,
gt; gt;
gt; gt; I manage a sports league, and one of my most common tasks is to make
gt; gt; the season schedule at the beginning of the year, where each time has
gt; gt; to play another, at different times of the week. Each team has sent me
gt; gt; a set of availability restrictions, daysamp;times of the week that they
gt; gt; are unable to play. Thus, when I make my schedule, I have to take these
gt; gt; restrictions into account.
gt; gt;
gt; gt; I have one separate worksheet for the game *schedule*, and another for
gt; gt; the *restrictions*. Thus in the worksheet quot;schedulequot; I have the home
gt; gt; team under column A, playing versus the away team on column B. In the
gt; gt; worksheet quot;restrictionsquot;, I have the team name under column A, and
gt; gt; their restrictions under column B.
gt; gt;
gt; gt; e.g.
gt; gt;
gt; gt; _\quot;Schedule\quot;_worksheet_
gt; gt; -Column A / Column B-
gt; gt; Footsies/ MISN Impossible
gt; gt; Money Shot / Rejects
gt; gt; Grrr / McGrads I
gt; gt; Pink Seagulls / Mailmen FC
gt; gt; etc.
gt; gt;
gt; gt; _\quot;Restrictions\quot;_worksheet_
gt; gt; -Column A / Column B-
gt; gt; Footsies / no Jan 9,12,16 no Feb 6-8
gt; gt; Money Shot / No Jan 9, No Thursdays
gt; gt; Grrr / no Jan 16
gt; gt; etc.
gt; gt;
gt; gt; My question: is there a way in Excel to set up columns C amp; D in the
gt; gt; worksheet quot;schedulequot; such that it returns the restrictions I have set
gt; gt; up in the worksheet quot;restrictionsquot;? (column C for the home team, and
gt; gt; column D for the away team). I basically need a function that goes
gt; gt; through the list in A, matches the team name in the restrictions
gt; gt; worksheet, and then returns the restriction quot;valuequot; (which is in fact,
gt; gt; text) in the quot;schedulequot; worksheet.
gt; gt;
gt; gt; I tried the quot;IFquot; function, but it doesn't work. Any help would be
gt; gt; appreciated.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; mpanty
gt; gt; ------------------------------------------------------------------------
gt; gt; mpanty's Profile: www.excelforum.com/member.php...oamp;userid=21377
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=501194
gt; gt;
gt; gt;


Thank you very much Paul! Worked like a charm!

One thing you forgot however :P was to specify the quot;Col_index_numquot;. The
function is in fact with the format
VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) where
Col_index_num is the column number in table_array from which the
matching value must be returned. A col_index_num of 1 returns the value
in the first column in table_array; a col_index_num of 2 returns the
value in the second column in table_array, and so on. In my case, I
needed quot;2quot;.

But thanks again! --
mpanty
------------------------------------------------------------------------
mpanty's Profile: www.excelforum.com/member.php...oamp;userid=21377
View this thread: www.excelforum.com/showthread...hreadid=501194oops youre right,but glad you sorted it out....
--
paul
remove nospam for email addy!
quot;mpantyquot; wrote:

gt;
gt; Thank you very much Paul! Worked like a charm!
gt;
gt; One thing you forgot however :P was to specify the quot;Col_index_numquot;. The
gt; function is in fact with the format
gt; VLOOKUP(lookup_value,table_array,col_index_num,ran ge_lookup) where
gt; Col_index_num is the column number in table_array from which the
gt; matching value must be returned. A col_index_num of 1 returns the value
gt; in the first column in table_array; a col_index_num of 2 returns the
gt; value in the second column in table_array, and so on. In my case, I
gt; needed quot;2quot;.
gt;
gt; But thanks again!
gt;
gt;
gt; --
gt; mpanty
gt; ------------------------------------------------------------------------
gt; mpanty's Profile: www.excelforum.com/member.php...oamp;userid=21377
gt; View this thread: www.excelforum.com/showthread...hreadid=501194
gt;
gt;