Match 2 dates in columns return 3rd
up vote
0
down vote
favorite
I have a column of dates (A3:A89)
I have a column of text (B3:B89)
I have another column of dates, although the cells are formatted to show only the date (O6:O43)
I need to find a date that matches columns A & O.
When a match is found, I need the text on the same row as the matching date in column A, to appear in another cell in column P next to the date in column O.
windows microsoft-excel microsoft-excel-2016
edited Nov 14 at 17:12
Worthwelle
2,1832724
asked Nov 14 at 15:58
Derek M
11
add a comment |
up vote
0
down vote
favorite
I have a column of dates (A3:A89)
I have a column of text (B3:B89)
I have another column of dates, although the cells are formatted to show only the date (O6:O43)
I need to find a date that matches columns A & O.
When a match is found, I need the text on the same row as the matching date in column A, to appear in another cell in column P next to the date in column O.
windows microsoft-excel microsoft-excel-2016
edited Nov 14 at 17:12
Worthwelle
2,1832724
asked Nov 14 at 15:58
Derek M
11
After a little bit of tweaking I managed to use the first formula. Thanks very much for your much welcome help.
– Derek M
Nov 15 at 11:45
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have a column of dates (A3:A89)
I have a column of text (B3:B89)
I have another column of dates, although the cells are formatted to show only the date (O6:O43)
I need to find a date that matches columns A & O.
When a match is found, I need the text on the same row as the matching date in column A, to appear in another cell in column P next to the date in column O.
windows microsoft-excel microsoft-excel-2016
edited Nov 14 at 17:12
Worthwelle
2,1832724
asked Nov 14 at 15:58
Derek M
11
I have a column of dates (A3:A89)
I have a column of text (B3:B89)
I have another column of dates, although the cells are formatted to show only the date (O6:O43)
I need to find a date that matches columns A & O.
When a match is found, I need the text on the same row as the matching date in column A, to appear in another cell in column P next to the date in column O.
windows microsoft-excel microsoft-excel-2016
windows microsoft-excel microsoft-excel-2016
edited Nov 14 at 17:12
Worthwelle
2,1832724
asked Nov 14 at 15:58
Derek M
11
edited Nov 14 at 17:12
Worthwelle
2,1832724
asked Nov 14 at 15:58
Derek M
11
edited Nov 14 at 17:12
Worthwelle
2,1832724
edited Nov 14 at 17:12
Worthwelle
2,1832724
edited Nov 14 at 17:12
Worthwelle
2,1832724
2,1832724
asked Nov 14 at 15:58
Derek M
11
asked Nov 14 at 15:58
Derek M
11
asked Nov 14 at 15:58
Derek M
11
11
After a little bit of tweaking I managed to use the first formula. Thanks very much for your much welcome help.
– Derek M
Nov 15 at 11:45
add a comment |
After a little bit of tweaking I managed to use the first formula. Thanks very much for your much welcome help.
– Derek M
Nov 15 at 11:45
After a little bit of tweaking I managed to use the first formula. Thanks very much for your much welcome help.
– Derek M
Nov 15 at 11:45
After a little bit of tweaking I managed to use the first formula. Thanks very much for your much welcome help.
– Derek M
Nov 15 at 11:45
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
Fill in column P with a formula similar to:
=VLOOKUP(O6,A3:A89,2,TRUE)
Old answer:
=IF(VALUE(INT(A6))=VALUE(INT(O6)),B6,"")
edited Nov 14 at 18:55
Worthwelle
2,1832724
answered Nov 14 at 16:44
Brian
212
New contributor
Brian 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 |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
Fill in column P with a formula similar to:
=VLOOKUP(O6,A3:A89,2,TRUE)
Old answer:
=IF(VALUE(INT(A6))=VALUE(INT(O6)),B6,"")
edited Nov 14 at 18:55
Worthwelle
2,1832724
answered Nov 14 at 16:44
Brian
212
New contributor
Brian 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
Fill in column P with a formula similar to:
=VLOOKUP(O6,A3:A89,2,TRUE)
Old answer:
=IF(VALUE(INT(A6))=VALUE(INT(O6)),B6,"")
edited Nov 14 at 18:55
Worthwelle
2,1832724
answered Nov 14 at 16:44
Brian
212
New contributor
Brian 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
up vote
0
down vote
Fill in column P with a formula similar to:
=VLOOKUP(O6,A3:A89,2,TRUE)
Old answer:
=IF(VALUE(INT(A6))=VALUE(INT(O6)),B6,"")
edited Nov 14 at 18:55
Worthwelle
2,1832724
answered Nov 14 at 16:44
Brian
212
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Fill in column P with a formula similar to:
=VLOOKUP(O6,A3:A89,2,TRUE)
Old answer:
=IF(VALUE(INT(A6))=VALUE(INT(O6)),B6,"")
edited Nov 14 at 18:55
Worthwelle
2,1832724
answered Nov 14 at 16:44
Brian
212
New contributor
Brian 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 18:55
Worthwelle
2,1832724
edited Nov 14 at 18:55
Worthwelle
2,1832724
edited Nov 14 at 18:55
Worthwelle
2,1832724
2,1832724
answered Nov 14 at 16:44
Brian
212
New contributor
Brian 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 16:44
Brian
212
answered Nov 14 at 16:44
Brian
212
212
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Brian is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Brian 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 |
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%2f1375370%2fmatch-2-dates-in-columns-return-3rd%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
After a little bit of tweaking I managed to use the first formula. Thanks very much for your much welcome help.
– Derek M
Nov 15 at 11:45