[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Can I use a concatenated string to reference an Excel Worksheet and cell in a formula

Posted on 2012-03-10
2
Medium Priority
?
252 Views
Last Modified: 2012-03-10
I would like to type in a person's initials into a cell on one excel worksheet, and have the intials be part of the name of another worksheet, such that a cell within the second worksheet can be referenced in a formula.

Please see the accompanying file.
Using the sheet named 'Results':
Is is possible to input the initials 'KG' into cell A4 and have a formula constructed in B4 that points the sheet KG_JP cell B1, so returning the value 25 as the result.

If the initials in A4 are replaced with 'RE', the formula in B4 would then point to the sheet RE_JP cell B1 and return the value 30.
RotaQuestion-2.xlsx
0
Comment
Question by:quentinA
2 Comments
 
LVL 36

Accepted Solution

by:
Norie earned 2000 total points
ID: 37705107
You can use INDIRECT for this.

=INDIRECT("'"&A4&"_JP'!B1")
0
 

Author Closing Comment

by:quentinA
ID: 37705134
Thanks
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

590 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