merge data from one workbook to another

I am trying to import data from one workbook to another, but need to do two
things in this process. I need to compare data and only insert what is
missing. IE in one column of one workbook there is a group of client ID's.
IN the other workbook there is a sales associate for that client. I would
like to merge these so that excel automatically reads the client id and
inserts a new column with the sales associate for that id.

I'd use the VLOOKUP function.

"beck" wrote:

> I am trying to import data from one workbook to another, but need to do two
> things in this process. I need to compare data and only insert what is
> missing. IE in one column of one workbook there is a group of client ID's.
> IN the other workbook there is a sales associate for that client. I would
> like to merge these so that excel automatically reads the client id and
> inserts a new column with the sales associate for that id.