Solved

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

Posted on 2014-01-17
374 Views
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
Question by:Jim Horn
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 11

Accepted Solution

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

LVL 51

Assisted Solution

Rgonzo1971 earned 200 total points
ID: 39788780
HI

pls try

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

Regards
0

LVL 66

Author Closing Comment

ID: 39788798
Thanks.
0

## Featured Post

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
###### Suggested Courses
Course of the Month6 days, 2 hours left to enroll