We help IT Professionals succeed at work.

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

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
Comment
Watch Question

Analyst Assistant
BRONZE EXPERT
Commented:
You can use INDIRECT for this.

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

Author

Commented:
Thanks

Explore More ContentExplore courses, solutions, and other research materials related to this topic.