I want to create a dashboard with NFL teams and Super Bowl results. on the DASHBOARD sheet, how can I get my data to populate such that when I select a super bowl in the drop-down box, the team logos and information about the game (data from SUPER_BOWL_DATA sheet) shows up dynamically when a Super Bowl is selected? In the dashboard I want it to display the Super Bowl name (I, II, etc.) from the list, the logos of the teams that played in the selected game populate where the white spaces are, the scores below it (the = signs), and attendance and venue.
Help appreciated.
Thanks!
Help appreciated.
Thanks!