I'm trying to design a trade checker for an NBA fantasy league I'm in.

I have a list of teams in a range (named "Teams"), a list of players
in each team in a range (named "Players"), and a list of the salaries
for all the players in a range (named "Salaries").

I need to design the trade checker in a way that allows me to pick a
team from a drop-down list (through data validation), and have a
second drop-down automatically populated with the names of the players
of that particular team. Consequently, if I pick a player from the
second drop-down list, I need his salary to automatically pop up in a
cell next to his name. I need to create 3 such "Teams" drop-downs to
allow for the possibility of a 3-way trade.

Finally, when all of this set up, I need Excel to make sure that the
salaries of the players acquired by one team are within 125% +
$100,000 of the salaries they send out.

Is this feasible?