• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

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
0
Jim Horn
Asked:
Jim Horn
2 Solutions
 
Angelp1ayCommented:
You can use INDIRECT e.g:
INDIRECT("Game" & XX & "!$B$1")

Open in new window

0
 
Rgonzo1971Commented:
HI

pls try

=INDIRECT("'Game"&A1&"'!$A$1")

Open in new window


Regards
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now