What does =INDIRECT(!$F12) mean in excel?
I'm reviewing a model, where I keep on seeing the exclamation mark used before the cell letter name - as presented in the question header," =INDIRECT(!$F12) "
What does it mean? how it works? can someone please help me where can I read about such references?
this is used in naming cell
another formula made the same way
=IF(!N$7
Regards
microsoft-excel
asked Feb 1 at 4:37
Samer GuihadSamer Guihad
33
add a comment |
I'm reviewing a model, where I keep on seeing the exclamation mark used before the cell letter name - as presented in the question header," =INDIRECT(!$F12) "
What does it mean? how it works? can someone please help me where can I read about such references?
this is used in naming cell
another formula made the same way
=IF(!N$7
Regards
microsoft-excel
asked Feb 1 at 4:37
Samer GuihadSamer Guihad
33
add a comment |
I'm reviewing a model, where I keep on seeing the exclamation mark used before the cell letter name - as presented in the question header," =INDIRECT(!$F12) "
What does it mean? how it works? can someone please help me where can I read about such references?
this is used in naming cell
another formula made the same way
=IF(!N$7
Regards
microsoft-excel
asked Feb 1 at 4:37
Samer GuihadSamer Guihad
33
I'm reviewing a model, where I keep on seeing the exclamation mark used before the cell letter name - as presented in the question header," =INDIRECT(!$F12) "
What does it mean? how it works? can someone please help me where can I read about such references?
this is used in naming cell
another formula made the same way
=IF(!N$7
Regards
microsoft-excel
microsoft-excel
asked Feb 1 at 4:37
Samer GuihadSamer Guihad
33
asked Feb 1 at 4:37
Samer GuihadSamer Guihad
33
edited Feb 1 at 5:02
Samer Guihad
asked Feb 1 at 4:37
Samer GuihadSamer Guihad
33
asked Feb 1 at 4:37
Samer GuihadSamer Guihad
33
asked Feb 1 at 4:37
Samer GuihadSamer Guihad
33
33
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Are you by any chance looking in the Name Manager or in VBA code? You should not see an exclamation mark without a sheet name on the worksheet, itself. If you're seeing it on the worksheet, that would probably indicate a formula creation error.
That nomenclature can be used when defining a named range in the Name Manager. The exclamation mark connects the sheet name with the cell address. But if you have a case where the same named range is defined on multiple sheets, this method can be used to create a "generic" sheet reference. The named range is defined using the exclamation mark but no sheet name. When you use that named range on a specific worksheet, it will refer to the range on the active worksheet.
You can read more about this method here and here.
answered Feb 1 at 5:12
fixer1234fixer1234
19k144982
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1400843%2fwhat-does-indirectf12-mean-in-excel%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
Are you by any chance looking in the Name Manager or in VBA code? You should not see an exclamation mark without a sheet name on the worksheet, itself. If you're seeing it on the worksheet, that would probably indicate a formula creation error.
That nomenclature can be used when defining a named range in the Name Manager. The exclamation mark connects the sheet name with the cell address. But if you have a case where the same named range is defined on multiple sheets, this method can be used to create a "generic" sheet reference. The named range is defined using the exclamation mark but no sheet name. When you use that named range on a specific worksheet, it will refer to the range on the active worksheet.
You can read more about this method here and here.
answered Feb 1 at 5:12
fixer1234fixer1234
19k144982
add a comment |
Are you by any chance looking in the Name Manager or in VBA code? You should not see an exclamation mark without a sheet name on the worksheet, itself. If you're seeing it on the worksheet, that would probably indicate a formula creation error.
That nomenclature can be used when defining a named range in the Name Manager. The exclamation mark connects the sheet name with the cell address. But if you have a case where the same named range is defined on multiple sheets, this method can be used to create a "generic" sheet reference. The named range is defined using the exclamation mark but no sheet name. When you use that named range on a specific worksheet, it will refer to the range on the active worksheet.
You can read more about this method here and here.
answered Feb 1 at 5:12
fixer1234fixer1234
19k144982
add a comment |
Are you by any chance looking in the Name Manager or in VBA code? You should not see an exclamation mark without a sheet name on the worksheet, itself. If you're seeing it on the worksheet, that would probably indicate a formula creation error.
That nomenclature can be used when defining a named range in the Name Manager. The exclamation mark connects the sheet name with the cell address. But if you have a case where the same named range is defined on multiple sheets, this method can be used to create a "generic" sheet reference. The named range is defined using the exclamation mark but no sheet name. When you use that named range on a specific worksheet, it will refer to the range on the active worksheet.
You can read more about this method here and here.
answered Feb 1 at 5:12
fixer1234fixer1234
19k144982
Are you by any chance looking in the Name Manager or in VBA code? You should not see an exclamation mark without a sheet name on the worksheet, itself. If you're seeing it on the worksheet, that would probably indicate a formula creation error.
That nomenclature can be used when defining a named range in the Name Manager. The exclamation mark connects the sheet name with the cell address. But if you have a case where the same named range is defined on multiple sheets, this method can be used to create a "generic" sheet reference. The named range is defined using the exclamation mark but no sheet name. When you use that named range on a specific worksheet, it will refer to the range on the active worksheet.
You can read more about this method here and here.
answered Feb 1 at 5:12
fixer1234fixer1234
19k144982
edited Feb 1 at 6:30
answered Feb 1 at 5:12
fixer1234fixer1234
19k144982
answered Feb 1 at 5:12
fixer1234fixer1234
19k144982
answered Feb 1 at 5:12
fixer1234fixer1234
19k144982
19k144982
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1400843%2fwhat-does-indirectf12-mean-in-excel%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
