Sep 26 2021 12:46 PM
Sep 26 2021 12:52 PM
SolutionYou can use the INDIRECT function for this.
Let's say you enter the name of a team in cell B3, and you want to return the value of cell D20 on the sheet whose name is in B3, you can use
=INDIRECT("'"&B3&"'!D20")
When you change the team name in B3, the formula will automatically look at the sheet for the new team.
Sep 26 2021 01:18 PM
Sep 26 2021 12:52 PM
SolutionYou can use the INDIRECT function for this.
Let's say you enter the name of a team in cell B3, and you want to return the value of cell D20 on the sheet whose name is in B3, you can use
=INDIRECT("'"&B3&"'!D20")
When you change the team name in B3, the formula will automatically look at the sheet for the new team.