Can drop down menus be used with dynamic references?
I’m trying to create an interactive sports bracket, but I’m running into three areas that are giving me trouble:
-
Making an array to randomly place opponents in the bracket. I built a table containing the list of participants on a separate sheet, but when I randomize their draw for positions in the bracket, it doesn’t translate to the main page.
-
I created drop down menus to select the winner of each match, however, it doesn’t update after the team has been assigned to that specific match. If the selected team, “Team A”, was in cell J1, it returns “J1” rather than “Team A”.
-
Auto populating cells based on the selection from the drop down menus from the previous area. I thought a simple IF(f) would work, but maybe because everything else is wrong that it doesn’t function as I had hoped.
Posted Jun 14, 2025, 9:04 PM UTC