#NAME when linking Excel workbooks with IFExcel - working with multiple workbooksExcel: #NAME? appearing when...
Is the Joker left-handed?
What is the most common color to indicate the input-field is disabled?
Western buddy movie with a supernatural twist where a woman turns into an eagle at the end
What do you call someone who asks many questions?
Why can't we play rap on piano?
What is the word for reserving something for yourself before others do?
What's the difference between 'rename' and 'mv'?
How can I tell someone that I want to be his or her friend?
How do conventional missiles fly?
Has there ever been an airliner design involving reducing generator load by installing solar panels?
What does it mean to describe someone as a butt steak?
Intersection of two sorted vectors in C++
How much of data wrangling is a data scientist's job?
SSH "lag" in LAN on some machines, mixed distros
Facing a paradox: Earnshaw's theorem in one dimension
Twin primes whose sum is a cube
Theorems that impeded progress
Alternative to sending password over mail?
What is the intuition behind short exact sequences of groups; in particular, what is the intuition behind group extensions?
Is there a hemisphere-neutral way of specifying a season?
Arrow those variables!
Why is the 'in' operator throwing an error with a string literal instead of logging false?
Is it canonical bit space?
Is it unprofessional to ask if a job posting on GlassDoor is real?
#NAME when linking Excel workbooks with IF
Excel - working with multiple workbooksExcel: #NAME? appearing when linking/referencing other spreadsheets/workbook cellsExcel Workbooks and VBAHow to get relative worksheet references when copying formulas in Excel?Linking Excel WorkbooksReference Excel sheet with apostrophe in nameRobust linking of cells ExcelCell references sheet name multiple workbooksLinking data in 2 different Excel workbooks togetherLinking Multiple Excel Workbooks
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I'm trying to link multiple workbooks to one workbook in the same folder. This needs to be done every month with a new set of workbooks linking to the master workbook.
The workbooks that need to be updated/changed also change their naming convention in respect to the date and therefor I used IF.
My end goal is to copy the master in each folder, one for every month, and also have the workbooks that I need linked to it in the folder.
My first attempt, for February, worked but when I created the new March folder I get #NAME in the cells that are suppose to be linking.
My formula:
=IF($A$2="20190101",'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationJan 2019[MD 19502_KWHIN_20190101_20190201.xlsx]MD 19502_KWHIN_20190101_2019020'!B3,IF($A$2="20190201",'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationFeb 2019[MD 19502_KWHIN_20190201_20190301.xlsx]MD 19502_KWHIN_20190201_2019030'!B3,IF($A$2=”20190301”,'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationMar 2019[MD 19502_KWHIN_20190301_20190401.xlsx]MD 19502_KWHIN_20190301_2019040'!B3 ...continued for each month
The paths all seem to be correct and I get this when I show the calculation steps;
When I press evaluate it shows IF("20190301"=#Name?.'S:…
microsoft-excel worksheet-function
edited 10 hours ago
fixer1234
19.3k145082
asked 11 hours ago
KatKat
1
New contributor
Kat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I'm trying to link multiple workbooks to one workbook in the same folder. This needs to be done every month with a new set of workbooks linking to the master workbook.
The workbooks that need to be updated/changed also change their naming convention in respect to the date and therefor I used IF.
My end goal is to copy the master in each folder, one for every month, and also have the workbooks that I need linked to it in the folder.
My first attempt, for February, worked but when I created the new March folder I get #NAME in the cells that are suppose to be linking.
My formula:
=IF($A$2="20190101",'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationJan 2019[MD 19502_KWHIN_20190101_20190201.xlsx]MD 19502_KWHIN_20190101_2019020'!B3,IF($A$2="20190201",'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationFeb 2019[MD 19502_KWHIN_20190201_20190301.xlsx]MD 19502_KWHIN_20190201_2019030'!B3,IF($A$2=”20190301”,'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationMar 2019[MD 19502_KWHIN_20190301_20190401.xlsx]MD 19502_KWHIN_20190301_2019040'!B3 ...continued for each month
The paths all seem to be correct and I get this when I show the calculation steps;
When I press evaluate it shows IF("20190301"=#Name?.'S:…
microsoft-excel worksheet-function
edited 10 hours ago
fixer1234
19.3k145082
asked 11 hours ago
KatKat
1
New contributor
Kat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
”20190301”within your formula has two left quotes. Try deleting it and replacing it with"20190301"
– davidmneedham
10 hours ago
add a comment |
I'm trying to link multiple workbooks to one workbook in the same folder. This needs to be done every month with a new set of workbooks linking to the master workbook.
The workbooks that need to be updated/changed also change their naming convention in respect to the date and therefor I used IF.
My end goal is to copy the master in each folder, one for every month, and also have the workbooks that I need linked to it in the folder.
My first attempt, for February, worked but when I created the new March folder I get #NAME in the cells that are suppose to be linking.
My formula:
=IF($A$2="20190101",'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationJan 2019[MD 19502_KWHIN_20190101_20190201.xlsx]MD 19502_KWHIN_20190101_2019020'!B3,IF($A$2="20190201",'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationFeb 2019[MD 19502_KWHIN_20190201_20190301.xlsx]MD 19502_KWHIN_20190201_2019030'!B3,IF($A$2=”20190301”,'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationMar 2019[MD 19502_KWHIN_20190301_20190401.xlsx]MD 19502_KWHIN_20190301_2019040'!B3 ...continued for each month
The paths all seem to be correct and I get this when I show the calculation steps;
When I press evaluate it shows IF("20190301"=#Name?.'S:…
microsoft-excel worksheet-function
edited 10 hours ago
fixer1234
19.3k145082
asked 11 hours ago
KatKat
1
New contributor
Kat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'm trying to link multiple workbooks to one workbook in the same folder. This needs to be done every month with a new set of workbooks linking to the master workbook.
The workbooks that need to be updated/changed also change their naming convention in respect to the date and therefor I used IF.
My end goal is to copy the master in each folder, one for every month, and also have the workbooks that I need linked to it in the folder.
My first attempt, for February, worked but when I created the new March folder I get #NAME in the cells that are suppose to be linking.
My formula:
=IF($A$2="20190101",'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationJan 2019[MD 19502_KWHIN_20190101_20190201.xlsx]MD 19502_KWHIN_20190101_2019020'!B3,IF($A$2="20190201",'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationFeb 2019[MD 19502_KWHIN_20190201_20190301.xlsx]MD 19502_KWHIN_20190201_2019030'!B3,IF($A$2=”20190301”,'S:OfficeBilling & CollectingNorthstarAccount ReconciliationsGenerationMar 2019[MD 19502_KWHIN_20190301_20190401.xlsx]MD 19502_KWHIN_20190301_2019040'!B3 ...continued for each month
The paths all seem to be correct and I get this when I show the calculation steps;
When I press evaluate it shows IF("20190301"=#Name?.'S:…
microsoft-excel worksheet-function
microsoft-excel worksheet-function
edited 10 hours ago
fixer1234
19.3k145082
asked 11 hours ago
KatKat
1
New contributor
Kat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 10 hours ago
fixer1234
19.3k145082
asked 11 hours ago
KatKat
1
New contributor
Kat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 10 hours ago
fixer1234
19.3k145082
edited 10 hours ago
fixer1234
19.3k145082
edited 10 hours ago
fixer1234
19.3k145082
19.3k145082
asked 11 hours ago
KatKat
1
New contributor
Kat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 11 hours ago
KatKat
1
asked 11 hours ago
KatKat
1
1
New contributor
Kat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Kat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Kat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
”20190301”within your formula has two left quotes. Try deleting it and replacing it with"20190301"
– davidmneedham
10 hours ago
add a comment |
”20190301”within your formula has two left quotes. Try deleting it and replacing it with"20190301"
– davidmneedham
10 hours ago
”20190301” within your formula has two left quotes. Try deleting it and replacing it with"20190301"– davidmneedham
10 hours ago
”20190301” within your formula has two left quotes. Try deleting it and replacing it with"20190301"– davidmneedham
10 hours ago
add a comment |
0
active
oldest
votes
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
});
}
});
Kat is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1421562%2fname-when-linking-excel-workbooks-with-if%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Kat is a new contributor. Be nice, and check out our Code of Conduct.
Kat is a new contributor. Be nice, and check out our Code of Conduct.
Kat is a new contributor. Be nice, and check out our Code of Conduct.
Kat is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1421562%2fname-when-linking-excel-workbooks-with-if%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
”20190301”within your formula has two left quotes. Try deleting it and replacing it with"20190301"– davidmneedham
10 hours ago