Link to home
Start Free TrialLog in
Avatar of Jim Horn
Jim HornFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Angelp1ay
Angelp1ay
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Rgonzo1971
Rgonzo1971

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jim Horn

ASKER

Thanks.