Related:

- Compare two columns and return text string
- Display two columns in data validation list but return only one - Guide
- Beyond compare - Download - File management
- Flipkart return comments - Guide
- Zuma return - Download - Puzzle
- If cell contains date then return value ✓ - Excel Forum

## 1 response

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.