• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

NFL Super Bowl dashboard project

SNexcel

New Member
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!
 

Attachments

Hui

Excel Ninja
Staff member
SNexcel

Firstly, Welcome to the Chandoo.org Forums

On the Dashboard Worksheet

B16: =INDEX(Super_Bowl_Data!$D$2:$D$53,MATCH($G$4,Super_Bowl_Data!$B$2:$B$53,0))

L16: =INDEX(Super_Bowl_Data!$F$2:$F$53,MATCH($G$4,Super_Bowl_Data!$B$2:$B$53,0))

That will get you started

Pull these formula apart and understand what they are doing

To return the logo's have a read of:
https://chandoo.org/wp/dynamic-charts-in-excel/

I would also recommend against using merged Cells as you have
 
Top