Extracting Data from one Excel Doc to another
up vote
0
down vote
favorite
I don't have the exact verbiage here to use, so please bare with me. I cannot do screenshots due to proprietary information being in the data set.
Here is what I am trying to do and I am looking for the formula to help me do it. In Excel Doc 1 there contains Store and Region. Store is located in Column A and Region is located in Column L. I can of course move this around if need be.
In Excel Doc 2 only store number is available; however, I need the region in this document as well. How do I get the region in Excel doc 2 to match what is in Excel Doc 1?
Thanks! -Ashley
microsoft-excel microsoft-excel-2010
asked Nov 27 at 3:01
Ashley
1
add a comment |
up vote
0
down vote
favorite
I don't have the exact verbiage here to use, so please bare with me. I cannot do screenshots due to proprietary information being in the data set.
Here is what I am trying to do and I am looking for the formula to help me do it. In Excel Doc 1 there contains Store and Region. Store is located in Column A and Region is located in Column L. I can of course move this around if need be.
In Excel Doc 2 only store number is available; however, I need the region in this document as well. How do I get the region in Excel doc 2 to match what is in Excel Doc 1?
Thanks! -Ashley
microsoft-excel microsoft-excel-2010
asked Nov 27 at 3:01
Ashley
1
Try theVLOOKUPfunction.
– Blackwood
Nov 27 at 3:13
Could you provide a sample screenshot?
– Lee
Nov 27 at 9:51
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I don't have the exact verbiage here to use, so please bare with me. I cannot do screenshots due to proprietary information being in the data set.
Here is what I am trying to do and I am looking for the formula to help me do it. In Excel Doc 1 there contains Store and Region. Store is located in Column A and Region is located in Column L. I can of course move this around if need be.
In Excel Doc 2 only store number is available; however, I need the region in this document as well. How do I get the region in Excel doc 2 to match what is in Excel Doc 1?
Thanks! -Ashley
microsoft-excel microsoft-excel-2010
asked Nov 27 at 3:01
Ashley
1
I don't have the exact verbiage here to use, so please bare with me. I cannot do screenshots due to proprietary information being in the data set.
Here is what I am trying to do and I am looking for the formula to help me do it. In Excel Doc 1 there contains Store and Region. Store is located in Column A and Region is located in Column L. I can of course move this around if need be.
In Excel Doc 2 only store number is available; however, I need the region in this document as well. How do I get the region in Excel doc 2 to match what is in Excel Doc 1?
Thanks! -Ashley
microsoft-excel microsoft-excel-2010
microsoft-excel microsoft-excel-2010
asked Nov 27 at 3:01
Ashley
1
asked Nov 27 at 3:01
Ashley
1
asked Nov 27 at 3:01
Ashley
1
asked Nov 27 at 3:01
Ashley
1
asked Nov 27 at 3:01
Ashley
1
1
Try theVLOOKUPfunction.
– Blackwood
Nov 27 at 3:13
Could you provide a sample screenshot?
– Lee
Nov 27 at 9:51
add a comment |
Try theVLOOKUPfunction.
– Blackwood
Nov 27 at 3:13
Could you provide a sample screenshot?
– Lee
Nov 27 at 9:51
Try the
VLOOKUP function.– Blackwood
Nov 27 at 3:13
Try the
VLOOKUP function.– Blackwood
Nov 27 at 3:13
Could you provide a sample screenshot?
– Lee
Nov 27 at 9:51
Could you provide a sample screenshot?
– Lee
Nov 27 at 9:51
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
I'm assuming that the Store Numbers are written in Column A in Sheet 2.
Enter this Formula in Cell B2 of Sheet 2 and fill it down.
=IFERROR(VLOOKUP(A2,Sheet1!A2:L40,12,FALSE),"No Match")
Note,
12, in the above Formula is Column position
forColumn L.
IFERRORwill return No Match text when Formula doesn't found Store Number in Sheet 1.
Adjust cell references in the Formula as needed.
answered Nov 27 at 5:03
Rajesh S
3,5561522
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',
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%2f1378629%2fextracting-data-from-one-excel-doc-to-another%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
I'm assuming that the Store Numbers are written in Column A in Sheet 2.
Enter this Formula in Cell B2 of Sheet 2 and fill it down.
=IFERROR(VLOOKUP(A2,Sheet1!A2:L40,12,FALSE),"No Match")
Note,
12, in the above Formula is Column position
forColumn L.
IFERRORwill return No Match text when Formula doesn't found Store Number in Sheet 1.
Adjust cell references in the Formula as needed.
answered Nov 27 at 5:03
Rajesh S
3,5561522
add a comment |
up vote
0
down vote
I'm assuming that the Store Numbers are written in Column A in Sheet 2.
Enter this Formula in Cell B2 of Sheet 2 and fill it down.
=IFERROR(VLOOKUP(A2,Sheet1!A2:L40,12,FALSE),"No Match")
Note,
12, in the above Formula is Column position
forColumn L.
IFERRORwill return No Match text when Formula doesn't found Store Number in Sheet 1.
Adjust cell references in the Formula as needed.
answered Nov 27 at 5:03
Rajesh S
3,5561522
add a comment |
up vote
0
down vote
up vote
0
down vote
I'm assuming that the Store Numbers are written in Column A in Sheet 2.
Enter this Formula in Cell B2 of Sheet 2 and fill it down.
=IFERROR(VLOOKUP(A2,Sheet1!A2:L40,12,FALSE),"No Match")
Note,
12, in the above Formula is Column position
forColumn L.
IFERRORwill return No Match text when Formula doesn't found Store Number in Sheet 1.
Adjust cell references in the Formula as needed.
answered Nov 27 at 5:03
Rajesh S
3,5561522
I'm assuming that the Store Numbers are written in Column A in Sheet 2.
Enter this Formula in Cell B2 of Sheet 2 and fill it down.
=IFERROR(VLOOKUP(A2,Sheet1!A2:L40,12,FALSE),"No Match")
Note,
12, in the above Formula is Column position
forColumn L.
IFERRORwill return No Match text when Formula doesn't found Store Number in Sheet 1.
Adjust cell references in the Formula as needed.
answered Nov 27 at 5:03
Rajesh S
3,5561522
answered Nov 27 at 5:03
Rajesh S
3,5561522
answered Nov 27 at 5:03
Rajesh S
3,5561522
answered Nov 27 at 5:03
Rajesh S
3,5561522
3,5561522
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f1378629%2fextracting-data-from-one-excel-doc-to-another%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
Try the
VLOOKUPfunction.– Blackwood
Nov 27 at 3:13
Could you provide a sample screenshot?
– Lee
Nov 27 at 9:51