Merging data from two different documents

Posted by Roddy Lindsay on June 18, 2001 12:00 PM

Hello,
this is my first post and I am a bit of an Excel newbie. I have recently been given the task of combining data from two different Excel documents. In document A, column I is a list of different character combinations (e.g. 3HnS0d93k). Column II is a description of the meaning of that particular character combination. In document B, there is a column with some of the combinations in document A, and many other columns containing other information about the combinations. How do I merge the two so that I can match the data in column II in document A with the corresponding character combo in document B?

Thanks,
Roddy Lindsay

Posted by Russell on June 18, 2001 12:22 PM

Vlookup

Use Vlookup. So if your character combo data in Doc B is in Column A, put the following formula in column B (we'll start at row 2):

=VLOOKUP(A2, [DocumentA]Sheet1!$A$2:$B$2000, 2, FALSE)

Make sure you have the dollar signs. This assumes that the data in Document A is on sheet1 and is in row 2 through row 2000 in columns A & B.

Look up Vlookup in help for more details.

Hope this helps,

Russell