Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • 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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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