Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i link up 2 sets of data into 1 set of data in excel
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i link up 2 sets of data into 1 set of data in excel
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 "mike" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i link up 2 sets of data into 1 set of data in excel
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 ?? "Toppers" wrote: 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 "mike" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbers/Text data missing from excel to excel query? | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Link or Copy Excel Data to Calendar (for scheduling) for Visual Aid | Excel Discussion (Misc queries) |