Matching tables with unsorted data
I am trying to match the data from one table to another.
The primary table has two columns (an alpha item description in column A and a numeric value for that item in column B) in an unsorted order. The primary table must remain in this format, I can't sort them.
The secondary table of data I am trying to match also has two columns (an alpha item description in column A and a numeric item value in column B) in an unsorted order, is not sorted the same way and is missing some of the rows of the primary table.
I would like the primary table to search the secondary table for a matching item description and copy that items numerical value.
If the secondary table does not have that item I would like to leave that cell blank.
Is there an excel formula to resolve this issue. Since I am new to this formula I can't post an example. Thanks for the help.
microsoft-excel microsoft-excel-2010
edited Jun 5 '13 at 17:17
daxlerod
2,26611618
asked Jun 5 '13 at 17:02
Todd ATodd A
1114
add a comment |
I am trying to match the data from one table to another.
The primary table has two columns (an alpha item description in column A and a numeric value for that item in column B) in an unsorted order. The primary table must remain in this format, I can't sort them.
The secondary table of data I am trying to match also has two columns (an alpha item description in column A and a numeric item value in column B) in an unsorted order, is not sorted the same way and is missing some of the rows of the primary table.
I would like the primary table to search the secondary table for a matching item description and copy that items numerical value.
If the secondary table does not have that item I would like to leave that cell blank.
Is there an excel formula to resolve this issue. Since I am new to this formula I can't post an example. Thanks for the help.
microsoft-excel microsoft-excel-2010
edited Jun 5 '13 at 17:17
daxlerod
2,26611618
asked Jun 5 '13 at 17:02
Todd ATodd A
1114
2
VLOOKUPshould do the trick; wrap it in anIFERRORfunction to show blank when no match, as in:IFERROR(VLOOKUP(<cell_reference_of_value_to_lookup>,<range_to_look_in>,<column_with_values_to_return>,FALSE),""). The FALSE tellsVLOOKUPto only make an exact match.
– chuff
Jun 5 '13 at 17:11
add a comment |
I am trying to match the data from one table to another.
The primary table has two columns (an alpha item description in column A and a numeric value for that item in column B) in an unsorted order. The primary table must remain in this format, I can't sort them.
The secondary table of data I am trying to match also has two columns (an alpha item description in column A and a numeric item value in column B) in an unsorted order, is not sorted the same way and is missing some of the rows of the primary table.
I would like the primary table to search the secondary table for a matching item description and copy that items numerical value.
If the secondary table does not have that item I would like to leave that cell blank.
Is there an excel formula to resolve this issue. Since I am new to this formula I can't post an example. Thanks for the help.
microsoft-excel microsoft-excel-2010
edited Jun 5 '13 at 17:17
daxlerod
2,26611618
asked Jun 5 '13 at 17:02
Todd ATodd A
1114
I am trying to match the data from one table to another.
The primary table has two columns (an alpha item description in column A and a numeric value for that item in column B) in an unsorted order. The primary table must remain in this format, I can't sort them.
The secondary table of data I am trying to match also has two columns (an alpha item description in column A and a numeric item value in column B) in an unsorted order, is not sorted the same way and is missing some of the rows of the primary table.
I would like the primary table to search the secondary table for a matching item description and copy that items numerical value.
If the secondary table does not have that item I would like to leave that cell blank.
Is there an excel formula to resolve this issue. Since I am new to this formula I can't post an example. Thanks for the help.
microsoft-excel microsoft-excel-2010
microsoft-excel microsoft-excel-2010
edited Jun 5 '13 at 17:17
daxlerod
2,26611618
asked Jun 5 '13 at 17:02
Todd ATodd A
1114
edited Jun 5 '13 at 17:17
daxlerod
2,26611618
asked Jun 5 '13 at 17:02
Todd ATodd A
1114
edited Jun 5 '13 at 17:17
daxlerod
2,26611618
edited Jun 5 '13 at 17:17
daxlerod
2,26611618
edited Jun 5 '13 at 17:17
daxlerod
2,26611618
2,26611618
asked Jun 5 '13 at 17:02
Todd ATodd A
1114
asked Jun 5 '13 at 17:02
Todd ATodd A
1114
asked Jun 5 '13 at 17:02
Todd ATodd A
1114
1114
2
VLOOKUPshould do the trick; wrap it in anIFERRORfunction to show blank when no match, as in:IFERROR(VLOOKUP(<cell_reference_of_value_to_lookup>,<range_to_look_in>,<column_with_values_to_return>,FALSE),""). The FALSE tellsVLOOKUPto only make an exact match.
– chuff
Jun 5 '13 at 17:11
add a comment |
2
VLOOKUPshould do the trick; wrap it in anIFERRORfunction to show blank when no match, as in:IFERROR(VLOOKUP(<cell_reference_of_value_to_lookup>,<range_to_look_in>,<column_with_values_to_return>,FALSE),""). The FALSE tellsVLOOKUPto only make an exact match.
– chuff
Jun 5 '13 at 17:11
2
2
VLOOKUP should do the trick; wrap it in an IFERROR function to show blank when no match, as in: IFERROR(VLOOKUP(<cell_reference_of_value_to_lookup>,<range_to_look_in>,<column_with_values_to_return>,FALSE),""). The FALSE tells VLOOKUP to only make an exact match.– chuff
Jun 5 '13 at 17:11
VLOOKUP should do the trick; wrap it in an IFERROR function to show blank when no match, as in: IFERROR(VLOOKUP(<cell_reference_of_value_to_lookup>,<range_to_look_in>,<column_with_values_to_return>,FALSE),""). The FALSE tells VLOOKUP to only make an exact match.– chuff
Jun 5 '13 at 17:11
add a comment |
2 Answers
2
active
oldest
votes
Your question is a bit confusing. Maybe an example of your starting data would help.
However, this looks like a case where I'd use VLOOKUP. Here is the Microsoft Documentation on VLOOKUP.
Lets say Sheet 1 contains your primary table, and Sheet 2 contains your secondary table.
An example formula for cell B3 on Sheet 1 using VLOOKUP: =VLOOKUP($A3,Sheet2!A1:B210,2,FALSE)
The ID from Sheet 2 will show up in Column B.
By setting the fourth parameter to false, I've told VLOOKUP that the data is not sorted.
By default, or when the parameter is explicitly true, VLOOKUP assumes the data is sorted, and finds an approximate value. Setting it to false forces VLOOKUP to find an exact match.
However, if VLOOKUP can't find a match, it will show N/A. You want an empty cell, so you can wrap it in IFERROR. The example is changed to: =IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),"")
answered Jun 5 '13 at 17:12
daxleroddaxlerod
2,26611618
Maybe this will help clarify my issue. Sheet1 contains two columns(A= item description, B is currently empty) with 231 rows that can't be changed in any way. Sheet2 contains two columns(A= item description, B is a numerical value) with 210 rows, it can be sorted if necessary and is in a different order than sheet1. I need sheet1 to search sheet2 and enter sheet2 numerical value for the matching item on sheet1. If no item is found on sheet2, sheet1 value should be blank.
– Todd A
Jun 5 '13 at 17:49
OK, changed my answer to reflect your comment.
– daxlerod
Jun 5 '13 at 21:39
I tried this formula but it did not seem to do what I needed it to. Is there a way to make this work with three pages being searched (sheet 2 to sheet4)and returning the value to sheet1 ?
– Todd A
Jun 18 '13 at 15:33
Maybe something like=IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet3!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet4!A1:B210,2,FALSE),"")))
– daxlerod
Jun 18 '13 at 18:54
add a comment |
You can use Query from Excel Files :
- Define name for primary table dataset (Formulas tab -> Define name)
- Define name for secondary table dataset
- Go to Data tab, select "From Other Sources", and from the dropdown, select "From Microsoft Query"
- Select your workbook file and confirm that you want to merge the columns manually
- In the following window "Query from Excel Files", drag&drop the column A of first dataset into the column A of second dataset - a link between these columns will be created
- Go to File menu, click "Return Data to MS Office Excel", an Import Data dialog will pop up
- Select the sheet into which you would like the matched data to be imported
- Click OK - you should see matched data with columns from both tables
Or if you don't mind uploading your files to an online service, you can use for example http://www.gridoc.com/join-tables and match the tables using drag&drop (Disclaimer: I am author of the tool).
Hope this helps.
answered Jun 16 '14 at 15:38
endrijuendriju
24926
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%2f604119%2fmatching-tables-with-unsorted-data%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
Your question is a bit confusing. Maybe an example of your starting data would help.
However, this looks like a case where I'd use VLOOKUP. Here is the Microsoft Documentation on VLOOKUP.
Lets say Sheet 1 contains your primary table, and Sheet 2 contains your secondary table.
An example formula for cell B3 on Sheet 1 using VLOOKUP: =VLOOKUP($A3,Sheet2!A1:B210,2,FALSE)
The ID from Sheet 2 will show up in Column B.
By setting the fourth parameter to false, I've told VLOOKUP that the data is not sorted.
By default, or when the parameter is explicitly true, VLOOKUP assumes the data is sorted, and finds an approximate value. Setting it to false forces VLOOKUP to find an exact match.
However, if VLOOKUP can't find a match, it will show N/A. You want an empty cell, so you can wrap it in IFERROR. The example is changed to: =IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),"")
answered Jun 5 '13 at 17:12
daxleroddaxlerod
2,26611618
Maybe this will help clarify my issue. Sheet1 contains two columns(A= item description, B is currently empty) with 231 rows that can't be changed in any way. Sheet2 contains two columns(A= item description, B is a numerical value) with 210 rows, it can be sorted if necessary and is in a different order than sheet1. I need sheet1 to search sheet2 and enter sheet2 numerical value for the matching item on sheet1. If no item is found on sheet2, sheet1 value should be blank.
– Todd A
Jun 5 '13 at 17:49
OK, changed my answer to reflect your comment.
– daxlerod
Jun 5 '13 at 21:39
I tried this formula but it did not seem to do what I needed it to. Is there a way to make this work with three pages being searched (sheet 2 to sheet4)and returning the value to sheet1 ?
– Todd A
Jun 18 '13 at 15:33
Maybe something like=IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet3!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet4!A1:B210,2,FALSE),"")))
– daxlerod
Jun 18 '13 at 18:54
add a comment |
Your question is a bit confusing. Maybe an example of your starting data would help.
However, this looks like a case where I'd use VLOOKUP. Here is the Microsoft Documentation on VLOOKUP.
Lets say Sheet 1 contains your primary table, and Sheet 2 contains your secondary table.
An example formula for cell B3 on Sheet 1 using VLOOKUP: =VLOOKUP($A3,Sheet2!A1:B210,2,FALSE)
The ID from Sheet 2 will show up in Column B.
By setting the fourth parameter to false, I've told VLOOKUP that the data is not sorted.
By default, or when the parameter is explicitly true, VLOOKUP assumes the data is sorted, and finds an approximate value. Setting it to false forces VLOOKUP to find an exact match.
However, if VLOOKUP can't find a match, it will show N/A. You want an empty cell, so you can wrap it in IFERROR. The example is changed to: =IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),"")
answered Jun 5 '13 at 17:12
daxleroddaxlerod
2,26611618
Maybe this will help clarify my issue. Sheet1 contains two columns(A= item description, B is currently empty) with 231 rows that can't be changed in any way. Sheet2 contains two columns(A= item description, B is a numerical value) with 210 rows, it can be sorted if necessary and is in a different order than sheet1. I need sheet1 to search sheet2 and enter sheet2 numerical value for the matching item on sheet1. If no item is found on sheet2, sheet1 value should be blank.
– Todd A
Jun 5 '13 at 17:49
OK, changed my answer to reflect your comment.
– daxlerod
Jun 5 '13 at 21:39
I tried this formula but it did not seem to do what I needed it to. Is there a way to make this work with three pages being searched (sheet 2 to sheet4)and returning the value to sheet1 ?
– Todd A
Jun 18 '13 at 15:33
Maybe something like=IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet3!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet4!A1:B210,2,FALSE),"")))
– daxlerod
Jun 18 '13 at 18:54
add a comment |
Your question is a bit confusing. Maybe an example of your starting data would help.
However, this looks like a case where I'd use VLOOKUP. Here is the Microsoft Documentation on VLOOKUP.
Lets say Sheet 1 contains your primary table, and Sheet 2 contains your secondary table.
An example formula for cell B3 on Sheet 1 using VLOOKUP: =VLOOKUP($A3,Sheet2!A1:B210,2,FALSE)
The ID from Sheet 2 will show up in Column B.
By setting the fourth parameter to false, I've told VLOOKUP that the data is not sorted.
By default, or when the parameter is explicitly true, VLOOKUP assumes the data is sorted, and finds an approximate value. Setting it to false forces VLOOKUP to find an exact match.
However, if VLOOKUP can't find a match, it will show N/A. You want an empty cell, so you can wrap it in IFERROR. The example is changed to: =IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),"")
answered Jun 5 '13 at 17:12
daxleroddaxlerod
2,26611618
Your question is a bit confusing. Maybe an example of your starting data would help.
However, this looks like a case where I'd use VLOOKUP. Here is the Microsoft Documentation on VLOOKUP.
Lets say Sheet 1 contains your primary table, and Sheet 2 contains your secondary table.
An example formula for cell B3 on Sheet 1 using VLOOKUP: =VLOOKUP($A3,Sheet2!A1:B210,2,FALSE)
The ID from Sheet 2 will show up in Column B.
By setting the fourth parameter to false, I've told VLOOKUP that the data is not sorted.
By default, or when the parameter is explicitly true, VLOOKUP assumes the data is sorted, and finds an approximate value. Setting it to false forces VLOOKUP to find an exact match.
However, if VLOOKUP can't find a match, it will show N/A. You want an empty cell, so you can wrap it in IFERROR. The example is changed to: =IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),"")
answered Jun 5 '13 at 17:12
daxleroddaxlerod
2,26611618
edited Jun 5 '13 at 21:39
answered Jun 5 '13 at 17:12
daxleroddaxlerod
2,26611618
answered Jun 5 '13 at 17:12
daxleroddaxlerod
2,26611618
answered Jun 5 '13 at 17:12
daxleroddaxlerod
2,26611618
2,26611618
Maybe this will help clarify my issue. Sheet1 contains two columns(A= item description, B is currently empty) with 231 rows that can't be changed in any way. Sheet2 contains two columns(A= item description, B is a numerical value) with 210 rows, it can be sorted if necessary and is in a different order than sheet1. I need sheet1 to search sheet2 and enter sheet2 numerical value for the matching item on sheet1. If no item is found on sheet2, sheet1 value should be blank.
– Todd A
Jun 5 '13 at 17:49
OK, changed my answer to reflect your comment.
– daxlerod
Jun 5 '13 at 21:39
I tried this formula but it did not seem to do what I needed it to. Is there a way to make this work with three pages being searched (sheet 2 to sheet4)and returning the value to sheet1 ?
– Todd A
Jun 18 '13 at 15:33
Maybe something like=IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet3!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet4!A1:B210,2,FALSE),"")))
– daxlerod
Jun 18 '13 at 18:54
add a comment |
Maybe this will help clarify my issue. Sheet1 contains two columns(A= item description, B is currently empty) with 231 rows that can't be changed in any way. Sheet2 contains two columns(A= item description, B is a numerical value) with 210 rows, it can be sorted if necessary and is in a different order than sheet1. I need sheet1 to search sheet2 and enter sheet2 numerical value for the matching item on sheet1. If no item is found on sheet2, sheet1 value should be blank.
– Todd A
Jun 5 '13 at 17:49
OK, changed my answer to reflect your comment.
– daxlerod
Jun 5 '13 at 21:39
I tried this formula but it did not seem to do what I needed it to. Is there a way to make this work with three pages being searched (sheet 2 to sheet4)and returning the value to sheet1 ?
– Todd A
Jun 18 '13 at 15:33
Maybe something like=IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet3!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet4!A1:B210,2,FALSE),"")))
– daxlerod
Jun 18 '13 at 18:54
Maybe this will help clarify my issue. Sheet1 contains two columns(A= item description, B is currently empty) with 231 rows that can't be changed in any way. Sheet2 contains two columns(A= item description, B is a numerical value) with 210 rows, it can be sorted if necessary and is in a different order than sheet1. I need sheet1 to search sheet2 and enter sheet2 numerical value for the matching item on sheet1. If no item is found on sheet2, sheet1 value should be blank.
– Todd A
Jun 5 '13 at 17:49
Maybe this will help clarify my issue. Sheet1 contains two columns(A= item description, B is currently empty) with 231 rows that can't be changed in any way. Sheet2 contains two columns(A= item description, B is a numerical value) with 210 rows, it can be sorted if necessary and is in a different order than sheet1. I need sheet1 to search sheet2 and enter sheet2 numerical value for the matching item on sheet1. If no item is found on sheet2, sheet1 value should be blank.
– Todd A
Jun 5 '13 at 17:49
OK, changed my answer to reflect your comment.
– daxlerod
Jun 5 '13 at 21:39
OK, changed my answer to reflect your comment.
– daxlerod
Jun 5 '13 at 21:39
I tried this formula but it did not seem to do what I needed it to. Is there a way to make this work with three pages being searched (sheet 2 to sheet4)and returning the value to sheet1 ?
– Todd A
Jun 18 '13 at 15:33
I tried this formula but it did not seem to do what I needed it to. Is there a way to make this work with three pages being searched (sheet 2 to sheet4)and returning the value to sheet1 ?
– Todd A
Jun 18 '13 at 15:33
Maybe something like
=IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet3!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet4!A1:B210,2,FALSE),"")))– daxlerod
Jun 18 '13 at 18:54
Maybe something like
=IFERROR(VLOOKUP($A3,Sheet2!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet3!A1:B210,2,FALSE),IFERROR(VLOOKUP($A3,Sheet4!A1:B210,2,FALSE),"")))– daxlerod
Jun 18 '13 at 18:54
add a comment |
You can use Query from Excel Files :
- Define name for primary table dataset (Formulas tab -> Define name)
- Define name for secondary table dataset
- Go to Data tab, select "From Other Sources", and from the dropdown, select "From Microsoft Query"
- Select your workbook file and confirm that you want to merge the columns manually
- In the following window "Query from Excel Files", drag&drop the column A of first dataset into the column A of second dataset - a link between these columns will be created
- Go to File menu, click "Return Data to MS Office Excel", an Import Data dialog will pop up
- Select the sheet into which you would like the matched data to be imported
- Click OK - you should see matched data with columns from both tables
Or if you don't mind uploading your files to an online service, you can use for example http://www.gridoc.com/join-tables and match the tables using drag&drop (Disclaimer: I am author of the tool).
Hope this helps.
answered Jun 16 '14 at 15:38
endrijuendriju
24926
add a comment |
You can use Query from Excel Files :
- Define name for primary table dataset (Formulas tab -> Define name)
- Define name for secondary table dataset
- Go to Data tab, select "From Other Sources", and from the dropdown, select "From Microsoft Query"
- Select your workbook file and confirm that you want to merge the columns manually
- In the following window "Query from Excel Files", drag&drop the column A of first dataset into the column A of second dataset - a link between these columns will be created
- Go to File menu, click "Return Data to MS Office Excel", an Import Data dialog will pop up
- Select the sheet into which you would like the matched data to be imported
- Click OK - you should see matched data with columns from both tables
Or if you don't mind uploading your files to an online service, you can use for example http://www.gridoc.com/join-tables and match the tables using drag&drop (Disclaimer: I am author of the tool).
Hope this helps.
answered Jun 16 '14 at 15:38
endrijuendriju
24926
add a comment |
You can use Query from Excel Files :
- Define name for primary table dataset (Formulas tab -> Define name)
- Define name for secondary table dataset
- Go to Data tab, select "From Other Sources", and from the dropdown, select "From Microsoft Query"
- Select your workbook file and confirm that you want to merge the columns manually
- In the following window "Query from Excel Files", drag&drop the column A of first dataset into the column A of second dataset - a link between these columns will be created
- Go to File menu, click "Return Data to MS Office Excel", an Import Data dialog will pop up
- Select the sheet into which you would like the matched data to be imported
- Click OK - you should see matched data with columns from both tables
Or if you don't mind uploading your files to an online service, you can use for example http://www.gridoc.com/join-tables and match the tables using drag&drop (Disclaimer: I am author of the tool).
Hope this helps.
answered Jun 16 '14 at 15:38
endrijuendriju
24926
You can use Query from Excel Files :
- Define name for primary table dataset (Formulas tab -> Define name)
- Define name for secondary table dataset
- Go to Data tab, select "From Other Sources", and from the dropdown, select "From Microsoft Query"
- Select your workbook file and confirm that you want to merge the columns manually
- In the following window "Query from Excel Files", drag&drop the column A of first dataset into the column A of second dataset - a link between these columns will be created
- Go to File menu, click "Return Data to MS Office Excel", an Import Data dialog will pop up
- Select the sheet into which you would like the matched data to be imported
- Click OK - you should see matched data with columns from both tables
Or if you don't mind uploading your files to an online service, you can use for example http://www.gridoc.com/join-tables and match the tables using drag&drop (Disclaimer: I am author of the tool).
Hope this helps.
answered Jun 16 '14 at 15:38
endrijuendriju
24926
edited Apr 15 '18 at 22:39
answered Jun 16 '14 at 15:38
endrijuendriju
24926
answered Jun 16 '14 at 15:38
endrijuendriju
24926
answered Jun 16 '14 at 15:38
endrijuendriju
24926
24926
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%2f604119%2fmatching-tables-with-unsorted-data%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
2
VLOOKUPshould do the trick; wrap it in anIFERRORfunction to show blank when no match, as in:IFERROR(VLOOKUP(<cell_reference_of_value_to_lookup>,<range_to_look_in>,<column_with_values_to_return>,FALSE),""). The FALSE tellsVLOOKUPto only make an exact match.– chuff
Jun 5 '13 at 17:11