Hi All
I have created a league table for the Australian A-League that works dynamically when the results are inputted into the main datasheet. I would now like to create logos next/adjacent to the teams that move dynamically as the team moves up and down the league, as the results are inputted. Below is the league. Is it possible to create a formula that allows the right badge/crest to be placed in the badge column and this changes when the teams move up or down? I have the badges on a separate sheet and I have tested that I can display them using named ranges and it works (the only problem is, all the guidance I have found works on dropdown which is not practical). Any guidance will be greatly appreciated.
I have created a league table for the Australian A-League that works dynamically when the results are inputted into the main datasheet. I would now like to create logos next/adjacent to the teams that move dynamically as the team moves up and down the league, as the results are inputted. Below is the league. Is it possible to create a formula that allows the right badge/crest to be placed in the badge column and this changes when the teams move up or down? I have the badges on a separate sheet and I have tested that I can display them using named ranges and it works (the only problem is, all the guidance I have found works on dropdown which is not practical). Any guidance will be greatly appreciated.