View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Can you combine tables (represent a "join") in Excel?

Look at VLOOKUP function.

Match Names in A with those in B and get data from B into A.

"Chunka" wrote:

I usually take my Excel spreadsheets into Access to perform this task, then
bring them back to Excel. It would save me some time if it can be done in
Excel.

I have two tables. Table A has 5 columns & table B has 3. Both tables
contain a column with similiar info. I want to make a new table that contains
all columns from both tables. Following is an example of what I'm trying to
do. I am not actually dealing with this type of data, but thought it would be
easier to explain using this scenario.

Table A: Name, Address, DOB, SS#
Table B: Name, Child's Name, Phone#
New Table: Name, Address, DOB, SS#, Name, Status, Phone#
(FYI - the new table should contain every record from Table A, but only
those records from Table B where the "Names" match.)