Pull text from another cell into an INDIRECT formulaExcel formula to reference 'CELL TO THE LEFT'Return empty cell from formula in ExcelINDIRECT with column reference and row reference in different cellsPrevent cell numbers from incrementing in a formula in ExcelINDIRECT function to reference cell ranges of other worksheetsExcel formula that will let me show a data range in a cell based on the value in another cellHow to change cell reference when dragging an INDIRECT formula?Ignore cells where text is empty regardless of formulaMaking indirect function linking to another worksheet in excel dynamicInserting a formula as a cell reference to another formula
What does this value mean in a BJT datasheet?
What is the difference between a historical drama and a period drama?
How can power levels matter in a magic system that emphasizes control?
List comprehensions in Mathematica?
What is the addition in the re-released version of Avengers: Endgame?
Do intermediate subdomains need to exist?
Why no parachutes in the Orion AA2 abort test?
Can a wizard delay learning new spells from leveling up, and instead learn different spells later?
Interview Question - Card betting
Advice for making/keeping shredded chicken moist?
Does a multiclassed wizard start with a spellbook?
Explain how 'Sharing the burden' puzzle from Professor Layton and the Miracle Mask should be solved
Has there ever been a cold war other than between the U.S. and the U.S.S.R.?
What/Where usage English vs Japanese
What does the ash content of broken wheat really mean?
What is the maximum amount of diamond in one Minecraft game?
Why would "dead languages" be the only languages that spells could be written in?
How to improve the size of cells in this table?
How to respond to someone who condemns behavior similar to what they exhibit?
What is this arch-and-tower near a road?
Why did the "Orks" never develop better firearms than Firelances and Handcannons?
Should I cheat if the majority does it?
How can I effectively map a multi-level dungeon?
How to supply water to a coastal desert town with no rain and no freshwater aquifers?
Pull text from another cell into an INDIRECT formula
Excel formula to reference 'CELL TO THE LEFT'Return empty cell from formula in ExcelINDIRECT with column reference and row reference in different cellsPrevent cell numbers from incrementing in a formula in ExcelINDIRECT function to reference cell ranges of other worksheetsExcel formula that will let me show a data range in a cell based on the value in another cellHow to change cell reference when dragging an INDIRECT formula?Ignore cells where text is empty regardless of formulaMaking indirect function linking to another worksheet in excel dynamicInserting a formula as a cell reference to another formula
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I'm using the INDIRECT formula to extract data from specific cells in hundreds of different sheets. In column B, I've listed all of the cells I need data from, and the worksheet names are in row 6. Any suggestions on how to exract the cell number from column B?
I've tried using text strings and the CONCATENATE function, but because of the quotations, I'm getting a reference error.
=INDIRECT("'"&$C$6&"'!M8")
I want to pull data from cell M8 in every sheet, but "M8" is listed in cell B2.
excel excel-formula
edited Mar 25 at 19:04
Scott Craner
97.6k8 gold badges27 silver badges53 bronze badges
asked Mar 25 at 19:03
AmberNAmberN
32 bronze badges
add a comment |
I'm using the INDIRECT formula to extract data from specific cells in hundreds of different sheets. In column B, I've listed all of the cells I need data from, and the worksheet names are in row 6. Any suggestions on how to exract the cell number from column B?
I've tried using text strings and the CONCATENATE function, but because of the quotations, I'm getting a reference error.
=INDIRECT("'"&$C$6&"'!M8")
I want to pull data from cell M8 in every sheet, but "M8" is listed in cell B2.
excel excel-formula
edited Mar 25 at 19:04
Scott Craner
97.6k8 gold badges27 silver badges53 bronze badges
asked Mar 25 at 19:03
AmberNAmberN
32 bronze badges
=INDIRECT("'"&$C$6&"'!"&B2)?
– BruceWayne
Mar 25 at 19:15
add a comment |
I'm using the INDIRECT formula to extract data from specific cells in hundreds of different sheets. In column B, I've listed all of the cells I need data from, and the worksheet names are in row 6. Any suggestions on how to exract the cell number from column B?
I've tried using text strings and the CONCATENATE function, but because of the quotations, I'm getting a reference error.
=INDIRECT("'"&$C$6&"'!M8")
I want to pull data from cell M8 in every sheet, but "M8" is listed in cell B2.
excel excel-formula
edited Mar 25 at 19:04
Scott Craner
97.6k8 gold badges27 silver badges53 bronze badges
asked Mar 25 at 19:03
AmberNAmberN
32 bronze badges
I'm using the INDIRECT formula to extract data from specific cells in hundreds of different sheets. In column B, I've listed all of the cells I need data from, and the worksheet names are in row 6. Any suggestions on how to exract the cell number from column B?
I've tried using text strings and the CONCATENATE function, but because of the quotations, I'm getting a reference error.
=INDIRECT("'"&$C$6&"'!M8")
I want to pull data from cell M8 in every sheet, but "M8" is listed in cell B2.
excel excel-formula
excel excel-formula
edited Mar 25 at 19:04
Scott Craner
97.6k8 gold badges27 silver badges53 bronze badges
asked Mar 25 at 19:03
AmberNAmberN
32 bronze badges
edited Mar 25 at 19:04
Scott Craner
97.6k8 gold badges27 silver badges53 bronze badges
asked Mar 25 at 19:03
AmberNAmberN
32 bronze badges
edited Mar 25 at 19:04
Scott Craner
97.6k8 gold badges27 silver badges53 bronze badges
edited Mar 25 at 19:04
Scott Craner
97.6k8 gold badges27 silver badges53 bronze badges
edited Mar 25 at 19:04
Scott Craner
97.6k8 gold badges27 silver badges53 bronze badges
97.6k8 gold badges27 silver badges53 bronze badges
asked Mar 25 at 19:03
AmberNAmberN
32 bronze badges
asked Mar 25 at 19:03
AmberNAmberN
32 bronze badges
asked Mar 25 at 19:03
AmberNAmberN
32 bronze badges
32 bronze badges
=INDIRECT("'"&$C$6&"'!"&B2)?
– BruceWayne
Mar 25 at 19:15
add a comment |
=INDIRECT("'"&$C$6&"'!"&B2)?
– BruceWayne
Mar 25 at 19:15
=INDIRECT("'"&$C$6&"'!"&B2)?– BruceWayne
Mar 25 at 19:15
=INDIRECT("'"&$C$6&"'!"&B2)?– BruceWayne
Mar 25 at 19:15
add a comment |
1 Answer
1
active
oldest
votes
Try:
=INDIRECT("'"&$C$6&"'!"&B2)
You have to use the Value in cell B2.
answered Mar 25 at 19:15
dwironydwirony
4,7783 gold badges14 silver badges34 bronze badges
Perfect, that worked. Thank you! I was trying to reference the cell inside of the quotations, after the exclamation mark.
– AmberN
Mar 25 at 19:24
@AmberN If that worked for you, you can flag it as the Answer by clicking the check mark left of the post (under the up/down arrows).
– BruceWayne
Mar 25 at 19:26
1
@BruceWayne Thanks Bruce, I saw your comment go right as I was submitting :)
– dwirony
Mar 25 at 19:33
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55344814%2fpull-text-from-another-cell-into-an-indirect-formula%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Try:
=INDIRECT("'"&$C$6&"'!"&B2)
You have to use the Value in cell B2.
answered Mar 25 at 19:15
dwironydwirony
4,7783 gold badges14 silver badges34 bronze badges
Perfect, that worked. Thank you! I was trying to reference the cell inside of the quotations, after the exclamation mark.
– AmberN
Mar 25 at 19:24
@AmberN If that worked for you, you can flag it as the Answer by clicking the check mark left of the post (under the up/down arrows).
– BruceWayne
Mar 25 at 19:26
1
@BruceWayne Thanks Bruce, I saw your comment go right as I was submitting :)
– dwirony
Mar 25 at 19:33
add a comment |
Try:
=INDIRECT("'"&$C$6&"'!"&B2)
You have to use the Value in cell B2.
answered Mar 25 at 19:15
dwironydwirony
4,7783 gold badges14 silver badges34 bronze badges
Perfect, that worked. Thank you! I was trying to reference the cell inside of the quotations, after the exclamation mark.
– AmberN
Mar 25 at 19:24
@AmberN If that worked for you, you can flag it as the Answer by clicking the check mark left of the post (under the up/down arrows).
– BruceWayne
Mar 25 at 19:26
1
@BruceWayne Thanks Bruce, I saw your comment go right as I was submitting :)
– dwirony
Mar 25 at 19:33
add a comment |
Try:
=INDIRECT("'"&$C$6&"'!"&B2)
You have to use the Value in cell B2.
answered Mar 25 at 19:15
dwironydwirony
4,7783 gold badges14 silver badges34 bronze badges
Try:
=INDIRECT("'"&$C$6&"'!"&B2)
You have to use the Value in cell B2.
answered Mar 25 at 19:15
dwironydwirony
4,7783 gold badges14 silver badges34 bronze badges
answered Mar 25 at 19:15
dwironydwirony
4,7783 gold badges14 silver badges34 bronze badges
answered Mar 25 at 19:15
dwironydwirony
4,7783 gold badges14 silver badges34 bronze badges
answered Mar 25 at 19:15
dwironydwirony
4,7783 gold badges14 silver badges34 bronze badges
4,7783 gold badges14 silver badges34 bronze badges
Perfect, that worked. Thank you! I was trying to reference the cell inside of the quotations, after the exclamation mark.
– AmberN
Mar 25 at 19:24
@AmberN If that worked for you, you can flag it as the Answer by clicking the check mark left of the post (under the up/down arrows).
– BruceWayne
Mar 25 at 19:26
1
@BruceWayne Thanks Bruce, I saw your comment go right as I was submitting :)
– dwirony
Mar 25 at 19:33
add a comment |
Perfect, that worked. Thank you! I was trying to reference the cell inside of the quotations, after the exclamation mark.
– AmberN
Mar 25 at 19:24
@AmberN If that worked for you, you can flag it as the Answer by clicking the check mark left of the post (under the up/down arrows).
– BruceWayne
Mar 25 at 19:26
1
@BruceWayne Thanks Bruce, I saw your comment go right as I was submitting :)
– dwirony
Mar 25 at 19:33
Perfect, that worked. Thank you! I was trying to reference the cell inside of the quotations, after the exclamation mark.
– AmberN
Mar 25 at 19:24
Perfect, that worked. Thank you! I was trying to reference the cell inside of the quotations, after the exclamation mark.
– AmberN
Mar 25 at 19:24
@AmberN If that worked for you, you can flag it as the Answer by clicking the check mark left of the post (under the up/down arrows).
– BruceWayne
Mar 25 at 19:26
@AmberN If that worked for you, you can flag it as the Answer by clicking the check mark left of the post (under the up/down arrows).
– BruceWayne
Mar 25 at 19:26
1
1
@BruceWayne Thanks Bruce, I saw your comment go right as I was submitting :)
– dwirony
Mar 25 at 19:33
@BruceWayne Thanks Bruce, I saw your comment go right as I was submitting :)
– dwirony
Mar 25 at 19:33
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55344814%2fpull-text-from-another-cell-into-an-indirect-formula%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
=INDIRECT("'"&$C$6&"'!"&B2)?– BruceWayne
Mar 25 at 19:15