Combining Tables

M

metrueblood

I have two tables with different sets of information, but they have a column
in common - the ID number. The tables have differing numbers of rows, ie.
some of the ID numbers in one table are not in the other table. How do I go
about combining the two tables, so that the ID's match up, and the info from
one table is carried to the matching ID in the other table? Sure appreciate
your help on this - i'm under a lot of pressure to do this quickly, and
cannot afford the time to go line by line matching ID's!!! :) Thanks!
mary trueblood
 
J

Jim Rech

This is usually done with formulas using VLOOKUP or MATCH and INDEX. If you
want a simple example send me your email address.

--
Jim Rech
Excel MVP
|I have two tables with different sets of information, but they have a
column
| in common - the ID number. The tables have differing numbers of rows, ie.
| some of the ID numbers in one table are not in the other table. How do I
go
| about combining the two tables, so that the ID's match up, and the info
from
| one table is carried to the matching ID in the other table? Sure
appreciate
| your help on this - i'm under a lot of pressure to do this quickly, and
| cannot afford the time to go line by line matching ID's!!! :) Thanks!
| mary trueblood
 
J

Jim Rech

Sent at 5:05 EST

--
Jim Rech
Excel MVP
| Please do! my e-mail is [email protected]
| Thank you so very much!
| mary trueblood :)
|
| "Jim Rech" wrote:
|
| > This is usually done with formulas using VLOOKUP or MATCH and INDEX. If
you
| > want a simple example send me your email address.
| >
| > --
| > Jim Rech
| > Excel MVP
| > | > |I have two tables with different sets of information, but they have a
| > column
| > | in common - the ID number. The tables have differing numbers of rows,
ie.
| > | some of the ID numbers in one table are not in the other table. How
do I
| > go
| > | about combining the two tables, so that the ID's match up, and the
info
| > from
| > | one table is carried to the matching ID in the other table? Sure
| > appreciate
| > | your help on this - i'm under a lot of pressure to do this quickly,
and
| > | cannot afford the time to go line by line matching ID's!!! :)
Thanks!
| > | mary trueblood
| >
| >
| >
 
Top