Excel formula to populate from one column only if another is empty?
I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not explained it very well, I'm extremely new to excel!
Is there also a way of showing which column it has used? Apologies if I sound stupid! All help is appreciated!
microsoft-excel microsoft-excel-2010 worksheet-function microsoft-excel-2007
add a comment |
I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not explained it very well, I'm extremely new to excel!
Is there also a way of showing which column it has used? Apologies if I sound stupid! All help is appreciated!
microsoft-excel microsoft-excel-2010 worksheet-function microsoft-excel-2007
Welcome to Super User. Are you talking about a cell inU
orP
? Or the entire column? Have you done any research or tried anything yet? If you have, it would be helpful if you edit your question to include the formula you are trying.
– CharlieRB
Nov 14 '14 at 12:57
=IF(ISBLANK(A1),B1,A1)
should address the question in the title, for the benefit of others reaching this page.
– geotheory
Sep 21 '15 at 8:00
add a comment |
I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not explained it very well, I'm extremely new to excel!
Is there also a way of showing which column it has used? Apologies if I sound stupid! All help is appreciated!
microsoft-excel microsoft-excel-2010 worksheet-function microsoft-excel-2007
I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not explained it very well, I'm extremely new to excel!
Is there also a way of showing which column it has used? Apologies if I sound stupid! All help is appreciated!
microsoft-excel microsoft-excel-2010 worksheet-function microsoft-excel-2007
microsoft-excel microsoft-excel-2010 worksheet-function microsoft-excel-2007
asked Nov 14 '14 at 12:45
LyannaLyanna
1112
1112
Welcome to Super User. Are you talking about a cell inU
orP
? Or the entire column? Have you done any research or tried anything yet? If you have, it would be helpful if you edit your question to include the formula you are trying.
– CharlieRB
Nov 14 '14 at 12:57
=IF(ISBLANK(A1),B1,A1)
should address the question in the title, for the benefit of others reaching this page.
– geotheory
Sep 21 '15 at 8:00
add a comment |
Welcome to Super User. Are you talking about a cell inU
orP
? Or the entire column? Have you done any research or tried anything yet? If you have, it would be helpful if you edit your question to include the formula you are trying.
– CharlieRB
Nov 14 '14 at 12:57
=IF(ISBLANK(A1),B1,A1)
should address the question in the title, for the benefit of others reaching this page.
– geotheory
Sep 21 '15 at 8:00
Welcome to Super User. Are you talking about a cell in
U
or P
? Or the entire column? Have you done any research or tried anything yet? If you have, it would be helpful if you edit your question to include the formula you are trying.– CharlieRB
Nov 14 '14 at 12:57
Welcome to Super User. Are you talking about a cell in
U
or P
? Or the entire column? Have you done any research or tried anything yet? If you have, it would be helpful if you edit your question to include the formula you are trying.– CharlieRB
Nov 14 '14 at 12:57
=IF(ISBLANK(A1),B1,A1)
should address the question in the title, for the benefit of others reaching this page.– geotheory
Sep 21 '15 at 8:00
=IF(ISBLANK(A1),B1,A1)
should address the question in the title, for the benefit of others reaching this page.– geotheory
Sep 21 '15 at 8:00
add a comment |
2 Answers
2
active
oldest
votes
In U1 enter:
=IF(ISNA(P1),L1,P1)
and copy down.
NOTE:
the obvious =IF(P1="#N/A",L1,P1) will not work!
This does not work for P1 saying #NA. In that case, I want it to use L1 instead
– Lyanna
Nov 14 '14 at 14:16
You only mentioned #N/A and N/A in your Post, not #NA
– Gary's Student
Nov 14 '14 at 14:26
add a comment |
While there is an NEI (Not Enough Information) flavor to your question, if the value column P is usually a number or date and you want the value from column L is column P contains #N/A or N/A or #NA or even an actual Excel #N/A
error code then perhaps something like this would do.
=IFERROR(--P1, L1)
Please remember that we are not mind readers and our crystal balls are often cloudy. Some sample data together with the expected results goes a long way towards receiving a quick and accurate answer to your current dilemma.
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%2f840062%2fexcel-formula-to-populate-from-one-column-only-if-another-is-empty%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
In U1 enter:
=IF(ISNA(P1),L1,P1)
and copy down.
NOTE:
the obvious =IF(P1="#N/A",L1,P1) will not work!
This does not work for P1 saying #NA. In that case, I want it to use L1 instead
– Lyanna
Nov 14 '14 at 14:16
You only mentioned #N/A and N/A in your Post, not #NA
– Gary's Student
Nov 14 '14 at 14:26
add a comment |
In U1 enter:
=IF(ISNA(P1),L1,P1)
and copy down.
NOTE:
the obvious =IF(P1="#N/A",L1,P1) will not work!
This does not work for P1 saying #NA. In that case, I want it to use L1 instead
– Lyanna
Nov 14 '14 at 14:16
You only mentioned #N/A and N/A in your Post, not #NA
– Gary's Student
Nov 14 '14 at 14:26
add a comment |
In U1 enter:
=IF(ISNA(P1),L1,P1)
and copy down.
NOTE:
the obvious =IF(P1="#N/A",L1,P1) will not work!
In U1 enter:
=IF(ISNA(P1),L1,P1)
and copy down.
NOTE:
the obvious =IF(P1="#N/A",L1,P1) will not work!
answered Nov 14 '14 at 13:51
Gary's StudentGary's Student
13.6k31730
13.6k31730
This does not work for P1 saying #NA. In that case, I want it to use L1 instead
– Lyanna
Nov 14 '14 at 14:16
You only mentioned #N/A and N/A in your Post, not #NA
– Gary's Student
Nov 14 '14 at 14:26
add a comment |
This does not work for P1 saying #NA. In that case, I want it to use L1 instead
– Lyanna
Nov 14 '14 at 14:16
You only mentioned #N/A and N/A in your Post, not #NA
– Gary's Student
Nov 14 '14 at 14:26
This does not work for P1 saying #NA. In that case, I want it to use L1 instead
– Lyanna
Nov 14 '14 at 14:16
This does not work for P1 saying #NA. In that case, I want it to use L1 instead
– Lyanna
Nov 14 '14 at 14:16
You only mentioned #N/A and N/A in your Post, not #NA
– Gary's Student
Nov 14 '14 at 14:26
You only mentioned #N/A and N/A in your Post, not #NA
– Gary's Student
Nov 14 '14 at 14:26
add a comment |
While there is an NEI (Not Enough Information) flavor to your question, if the value column P is usually a number or date and you want the value from column L is column P contains #N/A or N/A or #NA or even an actual Excel #N/A
error code then perhaps something like this would do.
=IFERROR(--P1, L1)
Please remember that we are not mind readers and our crystal balls are often cloudy. Some sample data together with the expected results goes a long way towards receiving a quick and accurate answer to your current dilemma.
add a comment |
While there is an NEI (Not Enough Information) flavor to your question, if the value column P is usually a number or date and you want the value from column L is column P contains #N/A or N/A or #NA or even an actual Excel #N/A
error code then perhaps something like this would do.
=IFERROR(--P1, L1)
Please remember that we are not mind readers and our crystal balls are often cloudy. Some sample data together with the expected results goes a long way towards receiving a quick and accurate answer to your current dilemma.
add a comment |
While there is an NEI (Not Enough Information) flavor to your question, if the value column P is usually a number or date and you want the value from column L is column P contains #N/A or N/A or #NA or even an actual Excel #N/A
error code then perhaps something like this would do.
=IFERROR(--P1, L1)
Please remember that we are not mind readers and our crystal balls are often cloudy. Some sample data together with the expected results goes a long way towards receiving a quick and accurate answer to your current dilemma.
While there is an NEI (Not Enough Information) flavor to your question, if the value column P is usually a number or date and you want the value from column L is column P contains #N/A or N/A or #NA or even an actual Excel #N/A
error code then perhaps something like this would do.
=IFERROR(--P1, L1)
Please remember that we are not mind readers and our crystal balls are often cloudy. Some sample data together with the expected results goes a long way towards receiving a quick and accurate answer to your current dilemma.
answered Nov 14 '14 at 18:27
JeepedJeeped
1,249613
1,249613
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%2f840062%2fexcel-formula-to-populate-from-one-column-only-if-another-is-empty%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
Welcome to Super User. Are you talking about a cell in
U
orP
? Or the entire column? Have you done any research or tried anything yet? If you have, it would be helpful if you edit your question to include the formula you are trying.– CharlieRB
Nov 14 '14 at 12:57
=IF(ISBLANK(A1),B1,A1)
should address the question in the title, for the benefit of others reaching this page.– geotheory
Sep 21 '15 at 8:00