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
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
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
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
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
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
answered Nov 14 at 16:44
Brian
212
answered Nov 14 at 16:44
Brian
212
212
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