Using Drop-Down list with offset

[rzacharia21]

Hey to you all,

Thank you in advance and I appreciate the help. I am attempting to create an NBA model that pins one team against another. For the opponent, I am using a drop down list that has the 29 other teams listed and I want to be able to pull the rosters of each respective team once I choose that team on the drop down list (the rosters are listed on another worksheet in the workbook). I have been able to execute the roster change by using numerical values and the offset function, but I want to be able to use the drop down list instead of having the user change the number and then see the roster change. I have attached my model for better understanding, as I know I am probably confusing. Thanks.