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.
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
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
