Solved

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

Posted on 2012-03-10
2
238 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 33

Accepted Solution

by:
Norie earned 500 total points
Comment Utility
You can use INDIRECT for this.

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

Author Closing Comment

by:quentinA
Comment Utility
Thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This collection of functions covers all the normal rounding methods of just about any numeric value.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

763 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

12 Experts available now in Live!

Get 1:1 Help Now