EXCEL If cell x is empty fill cell y with cell z
up vote
0
down vote
favorite
If cell x from worksheet 1 is empty, fill cell y in worksheet 2 with cell z from worksheet 1
***If customer PO No (worksheet 1) is empty then use Quote No (worksheet 1) to fill Quote/PO No (worksheet 2)
microsoft-excel worksheet-function
edited Nov 14 at 11:48
Ahmed Ashour
986610
asked Nov 14 at 10:54
Danielle
31
New contributor
Danielle 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 |
up vote
0
down vote
favorite
If cell x from worksheet 1 is empty, fill cell y in worksheet 2 with cell z from worksheet 1
***If customer PO No (worksheet 1) is empty then use Quote No (worksheet 1) to fill Quote/PO No (worksheet 2)
microsoft-excel worksheet-function
edited Nov 14 at 11:48
Ahmed Ashour
986610
asked Nov 14 at 10:54
Danielle
31
New contributor
Danielle 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 |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
If cell x from worksheet 1 is empty, fill cell y in worksheet 2 with cell z from worksheet 1
***If customer PO No (worksheet 1) is empty then use Quote No (worksheet 1) to fill Quote/PO No (worksheet 2)
microsoft-excel worksheet-function
edited Nov 14 at 11:48
Ahmed Ashour
986610
asked Nov 14 at 10:54
Danielle
31
New contributor
Danielle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
If cell x from worksheet 1 is empty, fill cell y in worksheet 2 with cell z from worksheet 1
***If customer PO No (worksheet 1) is empty then use Quote No (worksheet 1) to fill Quote/PO No (worksheet 2)
microsoft-excel worksheet-function
microsoft-excel worksheet-function
edited Nov 14 at 11:48
Ahmed Ashour
986610
asked Nov 14 at 10:54
Danielle
31
New contributor
Danielle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 14 at 11:48
Ahmed Ashour
986610
asked Nov 14 at 10:54
Danielle
31
New contributor
Danielle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 14 at 11:48
Ahmed Ashour
986610
edited Nov 14 at 11:48
Ahmed Ashour
986610
edited Nov 14 at 11:48
Ahmed Ashour
986610
986610
asked Nov 14 at 10:54
Danielle
31
New contributor
Danielle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Nov 14 at 10:54
Danielle
31
asked Nov 14 at 10:54
Danielle
31
31
New contributor
Danielle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Danielle is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Danielle 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 |
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
Use following formula in cell Y of sheet 2
=IF(Sheet1!B1="",Sheet1!B2,"")
Sheet1 B1 is X
Sheet1 B2 is Z
edited Nov 14 at 11:49
Ahmed Ashour
986610
answered Nov 14 at 11:12
Swapnil
264
New contributor
Swapnil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Thank you, I also needed to add that it should use Sheet!B1 if not empty but I think I worked that part out...
– Danielle
Nov 14 at 11:46
1
=IF(ISBLANK(Sheet!B1),Sheet!B2,Sheet!B1)
– Danielle
Nov 14 at 11:47
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
Use following formula in cell Y of sheet 2
=IF(Sheet1!B1="",Sheet1!B2,"")
Sheet1 B1 is X
Sheet1 B2 is Z
edited Nov 14 at 11:49
Ahmed Ashour
986610
answered Nov 14 at 11:12
Swapnil
264
New contributor
Swapnil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Thank you, I also needed to add that it should use Sheet!B1 if not empty but I think I worked that part out...
– Danielle
Nov 14 at 11:46
1
=IF(ISBLANK(Sheet!B1),Sheet!B2,Sheet!B1)
– Danielle
Nov 14 at 11:47
add a comment |
up vote
1
down vote
accepted
Use following formula in cell Y of sheet 2
=IF(Sheet1!B1="",Sheet1!B2,"")
Sheet1 B1 is X
Sheet1 B2 is Z
edited Nov 14 at 11:49
Ahmed Ashour
986610
answered Nov 14 at 11:12
Swapnil
264
New contributor
Swapnil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Thank you, I also needed to add that it should use Sheet!B1 if not empty but I think I worked that part out...
– Danielle
Nov 14 at 11:46
1
=IF(ISBLANK(Sheet!B1),Sheet!B2,Sheet!B1)
– Danielle
Nov 14 at 11:47
add a comment |
up vote
1
down vote
accepted
up vote
1
down vote
accepted
Use following formula in cell Y of sheet 2
=IF(Sheet1!B1="",Sheet1!B2,"")
Sheet1 B1 is X
Sheet1 B2 is Z
edited Nov 14 at 11:49
Ahmed Ashour
986610
answered Nov 14 at 11:12
Swapnil
264
New contributor
Swapnil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Use following formula in cell Y of sheet 2
=IF(Sheet1!B1="",Sheet1!B2,"")
Sheet1 B1 is X
Sheet1 B2 is Z
edited Nov 14 at 11:49
Ahmed Ashour
986610
answered Nov 14 at 11:12
Swapnil
264
New contributor
Swapnil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Nov 14 at 11:49
Ahmed Ashour
986610
edited Nov 14 at 11:49
Ahmed Ashour
986610
edited Nov 14 at 11:49
Ahmed Ashour
986610
986610
answered Nov 14 at 11:12
Swapnil
264
New contributor
Swapnil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered Nov 14 at 11:12
Swapnil
264
answered Nov 14 at 11:12
Swapnil
264
264
New contributor
Swapnil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Swapnil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Swapnil is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Thank you, I also needed to add that it should use Sheet!B1 if not empty but I think I worked that part out...
– Danielle
Nov 14 at 11:46
1
=IF(ISBLANK(Sheet!B1),Sheet!B2,Sheet!B1)
– Danielle
Nov 14 at 11:47
add a comment |
Thank you, I also needed to add that it should use Sheet!B1 if not empty but I think I worked that part out...
– Danielle
Nov 14 at 11:46
1
=IF(ISBLANK(Sheet!B1),Sheet!B2,Sheet!B1)
– Danielle
Nov 14 at 11:47
Thank you, I also needed to add that it should use Sheet!B1 if not empty but I think I worked that part out...
– Danielle
Nov 14 at 11:46
Thank you, I also needed to add that it should use Sheet!B1 if not empty but I think I worked that part out...
– Danielle
Nov 14 at 11:46
1
1
=IF(ISBLANK(Sheet!B1),Sheet!B2,Sheet!B1)
– Danielle
Nov 14 at 11:47
=IF(ISBLANK(Sheet!B1),Sheet!B2,Sheet!B1)
– Danielle
Nov 14 at 11:47
add a comment |
Danielle is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Danielle is a new contributor. Be nice, and check out our Code of Conduct.
Danielle is a new contributor. Be nice, and check out our Code of Conduct.
Danielle is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
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%2f1375274%2fexcel-if-cell-x-is-empty-fill-cell-y-with-cell-z%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
