Conditional Validation

[mojoshenpo]

I've made a team management sheet for a game. In one cell I have
validation for the team names. In another cell I would like to hav
conditional validation, i.e., when you choose a team name, a list o
available players is there for selection.

Someone said, on another forum, that they had combined IF statement
with Validation, but did not say how....

Help

 

[Guest]

Check this out from Dick Kusleika's Daily Dose of Excel...

http://www.dailydoseofexcel.com/archives/2004/05/11/conditional-data-validation/

I believe it will answer your questions.
--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.

 

[Gord Dibben]

What you need is dependent validation lists.

See Debra Dalgleish's site for instructions.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

 

[mojoshenpo]

Thanks to all for the last help; the page took a moderate amount o
figuring out, but the team manager sheet works nicely now.

Naturally, not being able to leave well enough alone, I'd like t
compile stats for the team vs other teams. How do I get excel to loo
up multiple instances of a value (opposing team) and return the sum o
the numbers from a column, i.e., you play a particular team 3 differen
times in a season and not back to back (unsorted data) how do you pic
out the total (sum) number of touchdowns/whatever that you score
against them from a table?

Thanks so much for the help,

Moj