Log In
Register
Home
New Member
March 3, 2022
Offline
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.
See Answer
July 16, 2010
Offline
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
Answers Post
New Member
March 3, 2022
Offline
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
1 Guest(s)
