Forum

Notifications
Clear all

Dynamic Football Crests

3 Posts
2 Users
0 Reactions
98 Views
(@william57)
Posts: 2
New Member
Topic starter
 

Hi All

I have a spreadsheet set up for the A-League.

I have a league sheet that has a table of the results as they happen.

The league sheet feeds a calculations page that ranks the teams according to the results.

The calculation sheet then feeds an output sheet that displays the correct league standings.

What I want to do is have the team logos next to the team (in another cell or if it was possible, next to the team in the same cell) and it moves up and down as the team moves up and down throughout the season.

 
Posted : 04/03/2022 7:53 am
(@mynda)
Posts: 4761
Member Admin
 

Hi William,

Welcome to our forum. You can use the technique explained in this tutorial on looking up pictures in Excel. Seeing that you don't need the data validation list, you can skip that part. You will need to create an INDIRECT named formula for each position in the table. In the attached file I've done the first two for you.

Mynda

 
Posted : 04/03/2022 8:40 pm
(@william57)
Posts: 2
New Member
Topic starter
 

HI Mynda

Thank you so much for spending the time to show me how it can be done and after having done a few trial runs it works perfectly.

I will now try to produce this on a dashboard I am generating for my son.

William

 
Posted : 05/03/2022 11:42 am
Share: