how do i link up 2 sets of data into 1 set of data in excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike - 19 Oct 2006 19:21 GMT

i want to concatenate 2 sets of data into 1 set. how do i line up like rows.
the basic dat sort doesnt work as not all of the data are the same in the 2
sets. i know you use concatenate somehow. the example is data set 1 is name
and phone numbers , data set 2 is names and addresses. i want to combine them
into one data set with names, phone numbers,and addresses.

Reply to this Message

Toppers - 19 Oct 2006 19:53 GMT

Mike,
Use VLOOKUP with "name" as search argument to retrieve the
corresponding data.

For example, use VLOOKUP to get the address data to be added to the 'phone
data for a given name.

Assuming name and telephone are in columns A& B of Sheet1 and name & address
are in columns A & B of Sheet2 then in column C (Cell C2) of sheet1 put

=VLOOKUP(A2,Sheet2!A:B,2,0)

this will match name in A2 against name in Sheet2 and return address from
column B.

HTH

> i want to concatenate 2 sets of data into 1 set. how do i line up like rows.
> the basic dat sort doesnt work as not all of the data are the same in the 2
> sets. i know you use concatenate somehow. the example is data set 1 is name
> and phone numbers , data set 2 is names and addresses. i want to combine them
> into one data set with names, phone numbers,and addresses.

Reply to this Message

romelsb - 21 Oct 2006 01:52 GMT

Excuse me Gord...Mike, Are you asking about one worksheet ? - do you need a
separate cell containing the merged info texts in every row...and then sort
it under one column containing the merged texts....and then do something else
??

> Mike,
> Use VLOOKUP with "name" as search argument to retrieve the
[quoted text clipped - 18 lines]
> > and phone numbers , data set 2 is names and addresses. i want to combine them
> > into one data set with names, phone numbers,and addresses.

Reply to this Message