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

[Guest]

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.

 

[Guest]

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

 

[Guest]

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
??