
New Member

March 3, 2022

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.


July 16, 2010

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
1 Guest(s)
