map data from two tables?

J

joey

Hi

How do i map data from two or more tables using the unique ID .

The first table has a unique ID and name dOB address of patients. The
second table holds remainder of the patients data relating to nature of
illness and treatment and it also has a unique ID.

How can i Join or map the two tables to make it into one table?

I'm using Excel 2003

Your help would be very much appreciated
joey
 
S

Sheeloo

You can use VLOOKUP on Id and add the DOB/Address information to the other
information.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Assignment Unique ID Different in Extract Map 0
Format column widths from one table to a separate table on same page 1
Creating a Search using a combo box and then creating a report. 4
Adding data to MS Access from csv file 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Dealing with a Pivot Table (when I don't want to) 0
How to read data from the workbook selectively? 4

Top