Converting Monthly Data to Daily Data on Excel for Mac
I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular month's value mentioned for every day of the month. I tried using VLOOKUP() but was unsuccessful.
A screenshot of the data sheet can be seen below.
microsoft-excel worksheet-function vlookup
edited Apr 6 '17 at 5:06
G-Man
5,687112359
asked Jan 14 '14 at 3:03
user3192485user3192485
612
add a comment |
I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular month's value mentioned for every day of the month. I tried using VLOOKUP() but was unsuccessful.
A screenshot of the data sheet can be seen below.
microsoft-excel worksheet-function vlookup
edited Apr 6 '17 at 5:06
G-Man
5,687112359
asked Jan 14 '14 at 3:03
user3192485user3192485
612
Why doesn'tvlookupwork? This is exactly what it does.
– Raystafarian
Jan 14 '14 at 13:47
add a comment |
I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular month's value mentioned for every day of the month. I tried using VLOOKUP() but was unsuccessful.
A screenshot of the data sheet can be seen below.
microsoft-excel worksheet-function vlookup
edited Apr 6 '17 at 5:06
G-Man
5,687112359
asked Jan 14 '14 at 3:03
user3192485user3192485
612
I have data columns of the last day of each month with a value. Apparently, the value of the entire month is stationary. I have to make a new column with daily dates while having the particular month's value mentioned for every day of the month. I tried using VLOOKUP() but was unsuccessful.
A screenshot of the data sheet can be seen below.
microsoft-excel worksheet-function vlookup
microsoft-excel worksheet-function vlookup
edited Apr 6 '17 at 5:06
G-Man
5,687112359
asked Jan 14 '14 at 3:03
user3192485user3192485
612
edited Apr 6 '17 at 5:06
G-Man
5,687112359
asked Jan 14 '14 at 3:03
user3192485user3192485
612
edited Apr 6 '17 at 5:06
G-Man
5,687112359
edited Apr 6 '17 at 5:06
G-Man
5,687112359
edited Apr 6 '17 at 5:06
G-Man
5,687112359
5,687112359
asked Jan 14 '14 at 3:03
user3192485user3192485
612
asked Jan 14 '14 at 3:03
user3192485user3192485
612
asked Jan 14 '14 at 3:03
user3192485user3192485
612
612
Why doesn'tvlookupwork? This is exactly what it does.
– Raystafarian
Jan 14 '14 at 13:47
add a comment |
Why doesn'tvlookupwork? This is exactly what it does.
– Raystafarian
Jan 14 '14 at 13:47
Why doesn't
vlookup work? This is exactly what it does.– Raystafarian
Jan 14 '14 at 13:47
Why doesn't
vlookup work? This is exactly what it does.– Raystafarian
Jan 14 '14 at 13:47
add a comment |
2 Answers
2
active
oldest
votes
Use a vlookup like this -
=vlookup(E2,$A$2:$B$12,2,true)
The key being the true -
Range_lookup A logical value that specifies whether you want
VLOOKUP to find an exact match or an approximate match:
If TRUE or omitted, an exact or approximate match is returned. If an
exact match is not found, the next largest value that is less than
lookup_value is returned.
answered Jan 14 '14 at 13:46
RaystafarianRaystafarian
19.5k105089
add a comment |
You might try index:
=INDEX($B$2:$B$12,MATCH(EOMONTH($D2,0),$A$2:$A$12,0))
answered Dec 22 '15 at 12:48
Patrick LamoreuxPatrick Lamoreux
11
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%2f701328%2fconverting-monthly-data-to-daily-data-on-excel-for-mac%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
Use a vlookup like this -
=vlookup(E2,$A$2:$B$12,2,true)
The key being the true -
Range_lookup A logical value that specifies whether you want
VLOOKUP to find an exact match or an approximate match:
If TRUE or omitted, an exact or approximate match is returned. If an
exact match is not found, the next largest value that is less than
lookup_value is returned.
answered Jan 14 '14 at 13:46
RaystafarianRaystafarian
19.5k105089
add a comment |
Use a vlookup like this -
=vlookup(E2,$A$2:$B$12,2,true)
The key being the true -
Range_lookup A logical value that specifies whether you want
VLOOKUP to find an exact match or an approximate match:
If TRUE or omitted, an exact or approximate match is returned. If an
exact match is not found, the next largest value that is less than
lookup_value is returned.
answered Jan 14 '14 at 13:46
RaystafarianRaystafarian
19.5k105089
add a comment |
Use a vlookup like this -
=vlookup(E2,$A$2:$B$12,2,true)
The key being the true -
Range_lookup A logical value that specifies whether you want
VLOOKUP to find an exact match or an approximate match:
If TRUE or omitted, an exact or approximate match is returned. If an
exact match is not found, the next largest value that is less than
lookup_value is returned.
answered Jan 14 '14 at 13:46
RaystafarianRaystafarian
19.5k105089
Use a vlookup like this -
=vlookup(E2,$A$2:$B$12,2,true)
The key being the true -
Range_lookup A logical value that specifies whether you want
VLOOKUP to find an exact match or an approximate match:
If TRUE or omitted, an exact or approximate match is returned. If an
exact match is not found, the next largest value that is less than
lookup_value is returned.
answered Jan 14 '14 at 13:46
RaystafarianRaystafarian
19.5k105089
answered Jan 14 '14 at 13:46
RaystafarianRaystafarian
19.5k105089
answered Jan 14 '14 at 13:46
RaystafarianRaystafarian
19.5k105089
answered Jan 14 '14 at 13:46
RaystafarianRaystafarian
19.5k105089
19.5k105089
add a comment |
add a comment |
You might try index:
=INDEX($B$2:$B$12,MATCH(EOMONTH($D2,0),$A$2:$A$12,0))
answered Dec 22 '15 at 12:48
Patrick LamoreuxPatrick Lamoreux
11
add a comment |
You might try index:
=INDEX($B$2:$B$12,MATCH(EOMONTH($D2,0),$A$2:$A$12,0))
answered Dec 22 '15 at 12:48
Patrick LamoreuxPatrick Lamoreux
11
add a comment |
You might try index:
=INDEX($B$2:$B$12,MATCH(EOMONTH($D2,0),$A$2:$A$12,0))
answered Dec 22 '15 at 12:48
Patrick LamoreuxPatrick Lamoreux
11
You might try index:
=INDEX($B$2:$B$12,MATCH(EOMONTH($D2,0),$A$2:$A$12,0))
answered Dec 22 '15 at 12:48
Patrick LamoreuxPatrick Lamoreux
11
answered Dec 22 '15 at 12:48
Patrick LamoreuxPatrick Lamoreux
11
answered Dec 22 '15 at 12:48
Patrick LamoreuxPatrick Lamoreux
11
answered Dec 22 '15 at 12:48
Patrick LamoreuxPatrick Lamoreux
11
11
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%2f701328%2fconverting-monthly-data-to-daily-data-on-excel-for-mac%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
Why doesn't
vlookupwork? This is exactly what it does.– Raystafarian
Jan 14 '14 at 13:47