Combining Tables
 

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

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
"metrueblood" wrote in message
...
|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

Please do! my e-mail is
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
"metrueblood" wrote in message
...
|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

Sent at 5:05 EST

--
Jim Rech
Excel MVP
"metrueblood" wrote in message
...
| Please do! my e-mail is
| 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
| "metrueblood" wrote in message
| ...
| |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
|
|
|