Thread
:
Combining Tables
View Single Post
#
3
metrueblood
Posts: n/a
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
Reply With Quote