Jim Horn
asked on
Excel: How to concatenate another cell value in tab name for a formula
Hi guys
I have tabs for Game1, Game2, Game3, ..., Game99.
I have a 'Totals' tab with column A that is 1, 2, 3, ...
Question: For columns B onward, what's the syntax for a formula if I wanted to grab (i.e. replace <whatever number value is in XX of current tab> with ???)
=Game<whatever number value is in A1 of current tab>!$B$1
=Game<whatever number value is in A2 of current tab>!$B$4
=Game<whatever number value is in A3 of current tab>!$B$7
Thanks.
Jim
I have tabs for Game1, Game2, Game3, ..., Game99.
I have a 'Totals' tab with column A that is 1, 2, 3, ...
Question: For columns B onward, what's the syntax for a formula if I wanted to grab (i.e. replace <whatever number value is in XX of current tab> with ???)
=Game<whatever number value is in A1 of current tab>!$B$1
=Game<whatever number value is in A2 of current tab>!$B$4
=Game<whatever number value is in A3 of current tab>!$B$7
Thanks.
Jim
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER