| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
map data from two tables?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
map data from two tables?
You can use VLOOKUP on Id and add the DOB/Address information to the other
information. "joey" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
| PLEASE ANYONE ... DATA IMPORT EXTERNAL DATA - WEB TABLES | Excel Discussion (Misc queries) | |||
| DATA > TABLE -- 2 variable data tables? | Excel Worksheet Functions | |||
| DATA > TABLE -- 2 variable data tables? | Excel Discussion (Misc queries) | |||
| How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) | |||
Linear Mode
