I have a draft coming up and want to use a spreadsheet to avoid highlighting off names everytime someone is picked.

The way I have it set up is on sheet1, I have the draft board, with 10 teams across the top and 15 rows down for the rounds.

Sheet2 is quarterbacks. When I enter a name that got picked on sheet one, say P. Manning, I want it to say "TAKEN" next to his name on the position sheet (sheet2).

I would actually like it to say the team name, but if only TAKEN is doable, that works for me. Please help, this would be a great advantage to have. Thanks in advance.