Match unsorted Excel data from two columns (products) to assign value to a third column (prices)
I have four columns:
Column A has a part number, column B has a new price
Column C has a part number, column D has an old price.
Column A and C are not identical nor do they have the same number of rows (column B has more rows as it includes obsolete part numbers) while not identical the columns have many identical part numbers.
Columns C and D have more entries than Columns A and B as they include obsolete products.
I want to match the new price from Column A to its corresponding part number in column C and place the new price in column E.
I need to keep the existing (sort) order in columns C as I have to import column C and E into an existing spreadsheet which has an row order that cannot be changed.
Sample of unmatched data columns (comma separated)
Part-code, New-Sell, Part-code(web), Old-sell
30X-BTA,$8.00,DCX-BTD,$9
Your help will be appreciated
microsoft-excel
edited Mar 19 '14 at 13:58
Der Hochstapler
67.9k49230285
asked Aug 31 '13 at 9:26
JohnJohn
613
add a comment |
I have four columns:
Column A has a part number, column B has a new price
Column C has a part number, column D has an old price.
Column A and C are not identical nor do they have the same number of rows (column B has more rows as it includes obsolete part numbers) while not identical the columns have many identical part numbers.
Columns C and D have more entries than Columns A and B as they include obsolete products.
I want to match the new price from Column A to its corresponding part number in column C and place the new price in column E.
I need to keep the existing (sort) order in columns C as I have to import column C and E into an existing spreadsheet which has an row order that cannot be changed.
Sample of unmatched data columns (comma separated)
Part-code, New-Sell, Part-code(web), Old-sell
30X-BTA,$8.00,DCX-BTD,$9
Your help will be appreciated
microsoft-excel
edited Mar 19 '14 at 13:58
Der Hochstapler
67.9k49230285
asked Aug 31 '13 at 9:26
JohnJohn
613
@Axel Kemper Do you want to post that as an answer?
– barry houdini
Aug 31 '13 at 15:05
add a comment |
I have four columns:
Column A has a part number, column B has a new price
Column C has a part number, column D has an old price.
Column A and C are not identical nor do they have the same number of rows (column B has more rows as it includes obsolete part numbers) while not identical the columns have many identical part numbers.
Columns C and D have more entries than Columns A and B as they include obsolete products.
I want to match the new price from Column A to its corresponding part number in column C and place the new price in column E.
I need to keep the existing (sort) order in columns C as I have to import column C and E into an existing spreadsheet which has an row order that cannot be changed.
Sample of unmatched data columns (comma separated)
Part-code, New-Sell, Part-code(web), Old-sell
30X-BTA,$8.00,DCX-BTD,$9
Your help will be appreciated
microsoft-excel
edited Mar 19 '14 at 13:58
Der Hochstapler
67.9k49230285
asked Aug 31 '13 at 9:26
JohnJohn
613
I have four columns:
Column A has a part number, column B has a new price
Column C has a part number, column D has an old price.
Column A and C are not identical nor do they have the same number of rows (column B has more rows as it includes obsolete part numbers) while not identical the columns have many identical part numbers.
Columns C and D have more entries than Columns A and B as they include obsolete products.
I want to match the new price from Column A to its corresponding part number in column C and place the new price in column E.
I need to keep the existing (sort) order in columns C as I have to import column C and E into an existing spreadsheet which has an row order that cannot be changed.
Sample of unmatched data columns (comma separated)
Part-code, New-Sell, Part-code(web), Old-sell
30X-BTA,$8.00,DCX-BTD,$9
Your help will be appreciated
microsoft-excel
microsoft-excel
edited Mar 19 '14 at 13:58
Der Hochstapler
67.9k49230285
asked Aug 31 '13 at 9:26
JohnJohn
613
edited Mar 19 '14 at 13:58
Der Hochstapler
67.9k49230285
asked Aug 31 '13 at 9:26
JohnJohn
613
edited Mar 19 '14 at 13:58
Der Hochstapler
67.9k49230285
edited Mar 19 '14 at 13:58
Der Hochstapler
67.9k49230285
edited Mar 19 '14 at 13:58
Der Hochstapler
67.9k49230285
67.9k49230285
asked Aug 31 '13 at 9:26
JohnJohn
613
asked Aug 31 '13 at 9:26
JohnJohn
613
asked Aug 31 '13 at 9:26
JohnJohn
613
613
@Axel Kemper Do you want to post that as an answer?
– barry houdini
Aug 31 '13 at 15:05
add a comment |
@Axel Kemper Do you want to post that as an answer?
– barry houdini
Aug 31 '13 at 15:05
@Axel Kemper Do you want to post that as an answer?
– barry houdini
Aug 31 '13 at 15:05
@Axel Kemper Do you want to post that as an answer?
– barry houdini
Aug 31 '13 at 15:05
add a comment |
1 Answer
1
active
oldest
votes
Excel's VLOOKUP function might be helpful here.
It can be used to lookup data using a key or an ID.
Link: http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx
answered Aug 31 '13 at 15:07
Axel KemperAxel Kemper
2,68711621
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%2f639087%2fmatch-unsorted-excel-data-from-two-columns-products-to-assign-value-to-a-third%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
Excel's VLOOKUP function might be helpful here.
It can be used to lookup data using a key or an ID.
Link: http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx
answered Aug 31 '13 at 15:07
Axel KemperAxel Kemper
2,68711621
add a comment |
Excel's VLOOKUP function might be helpful here.
It can be used to lookup data using a key or an ID.
Link: http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx
answered Aug 31 '13 at 15:07
Axel KemperAxel Kemper
2,68711621
add a comment |
Excel's VLOOKUP function might be helpful here.
It can be used to lookup data using a key or an ID.
Link: http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx
answered Aug 31 '13 at 15:07
Axel KemperAxel Kemper
2,68711621
Excel's VLOOKUP function might be helpful here.
It can be used to lookup data using a key or an ID.
Link: http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx
answered Aug 31 '13 at 15:07
Axel KemperAxel Kemper
2,68711621
answered Aug 31 '13 at 15:07
Axel KemperAxel Kemper
2,68711621
answered Aug 31 '13 at 15:07
Axel KemperAxel Kemper
2,68711621
answered Aug 31 '13 at 15:07
Axel KemperAxel Kemper
2,68711621
2,68711621
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%2f639087%2fmatch-unsorted-excel-data-from-two-columns-products-to-assign-value-to-a-third%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
@Axel Kemper Do you want to post that as an answer?
– barry houdini
Aug 31 '13 at 15:05