Solved

Excel:  How to concatenate another cell value in tab name for a formula

Posted on 2014-01-17
3
361 Views
Last Modified: 2014-01-17
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
Comment
Question by:Jim Horn
3 Comments
 
LVL 11

Accepted Solution

by:
Angelp1ay earned 300 total points
ID: 39788778
You can use INDIRECT e.g:
INDIRECT("Game" & XX & "!$B$1")

Open in new window

0
 
LVL 50

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 200 total points
ID: 39788780
HI

pls try

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

Open in new window


Regards
0
 
LVL 65

Author Closing Comment

by:Jim Horn
ID: 39788798
Thanks.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question