Related:
- Compare two columns and return text string
- Display two columns in data validation list but return only one - Guide
- Flipkart return comments - Guide
- Beyond compare - Download - File management
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Zuma return - Download - Puzzle
1 response
I'm replying to myself, which is pretty weird, but I found a solution at this site:
http://en.allexperts.com/q/Excel-1059/merge-columns-match-column.htm
Thought it would be nice for others with similar problems to know that there is a solution out there; at least it worked for me:)
Below I'm repeating the question and the answer on the web site I mention over, just in case anyone has a problem loading the web site:
/***Title: Excel/merge two columns (match column's text string) ***/
Expert: Nathan Head - 4/18/2007
Question
I would like to create a new column to describe LIST A. How to match the text string in LIST B with LIST A, and use the corresponding description from LIST B for LIST A?
LIST A LIST B description
111 111 111-000-111
111 222 222-000-222
333 333 333-000-333
333 444 444-000-444
333 555 555-000-555
333 666 666-000-666
444 777 777-000-777
555 888 888-000-888
666 999 999-000-999
777
777
777
777
888
888
999
Thanks!
Answer
Presuming I understand the question correctly, this can be done with VLOOKUP.
Setup:
1) List A {111,111,333,333,333,333,444, etc} is located in rows 2 through 17 of column A in Excel
2) List B {111,222,333,444, etc} is located in rows 2 through 10 of column D in Excel
3) The descriptions of list B are located in column E, also rows 2 through 10, immediately to the right of their respective numbers.
We now want the descriptions to appear immediately to the right of the numbers in column A.
Insert this formula into cell B2:
=VLOOKUP(A2,D:E,2,FALSE)
It essentially does this:
Take the value in A2, 111, and find it in column D. When it finds a match in column D, go "2" columns over (D=1, E=2) and return the value shown there. FALSE = Find an exact match.
You can simply copy the above formula down through Row 17 of column B to fill in the remainder of the descriptions.
Let me know if you need an example of this and I will email you a copy.
http://en.allexperts.com/q/Excel-1059/merge-columns-match-column.htm
Thought it would be nice for others with similar problems to know that there is a solution out there; at least it worked for me:)
Below I'm repeating the question and the answer on the web site I mention over, just in case anyone has a problem loading the web site:
/***Title: Excel/merge two columns (match column's text string) ***/
Expert: Nathan Head - 4/18/2007
Question
I would like to create a new column to describe LIST A. How to match the text string in LIST B with LIST A, and use the corresponding description from LIST B for LIST A?
LIST A LIST B description
111 111 111-000-111
111 222 222-000-222
333 333 333-000-333
333 444 444-000-444
333 555 555-000-555
333 666 666-000-666
444 777 777-000-777
555 888 888-000-888
666 999 999-000-999
777
777
777
777
888
888
999
Thanks!
Answer
Presuming I understand the question correctly, this can be done with VLOOKUP.
Setup:
1) List A {111,111,333,333,333,333,444, etc} is located in rows 2 through 17 of column A in Excel
2) List B {111,222,333,444, etc} is located in rows 2 through 10 of column D in Excel
3) The descriptions of list B are located in column E, also rows 2 through 10, immediately to the right of their respective numbers.
We now want the descriptions to appear immediately to the right of the numbers in column A.
Insert this formula into cell B2:
=VLOOKUP(A2,D:E,2,FALSE)
It essentially does this:
Take the value in A2, 111, and find it in column D. When it finds a match in column D, go "2" columns over (D=1, E=2) and return the value shown there. FALSE = Find an exact match.
You can simply copy the above formula down through Row 17 of column B to fill in the remainder of the descriptions.
Let me know if you need an example of this and I will email you a copy.
