I'm working on setting up a NFL Playoff Bracket and want to use Data
Validation to make in cell drop downs. I've made another sheet with all of
the teams and named the ranges for the 1st four games. The issue I am having
is setting up the next drop down list - This is because one team exists and
the other "selected" team will play in the next round. BUT there is the
comparision of seeds as to which team plays which...

How do I make the pseudo combo box show the apporiate team for a user to
select? Ideas? Thanks