Solved

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

Posted on 2014-01-17
3
351 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 48

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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Manipulate Data Quickly 2 13
TT Copy Formula 3 16
Top 10 with duplicates in Excel Table 4 10
Formula to convert ranked data 2 10
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

708 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now