Ok, i hope i can articulate this properly...
I have built a fantasy football team selector in excel. The sheet i am having trouble with works by using a drop down list to select a player. Once selected that player will then pull data from the master sheet and display it in other columns. e.g...