I'd probably use VLOOKUP to do this.

http://www.mvps.org/dmcritchie/excel/vlookup.htm

"Lovelock" <Lovelock, "David" wrote:


I have two excel workbooks that I need to update data from workbook 1
into workbook 2. The workbooks are both customer lists with customer
assigned to each person. In one book I have a customer code (A,B, or C)
assigned to each customer number. I need to copy that code for each
customer and enter it in a new column in workbook 2.

For example cust# 123 has code B assigned to them, I need to go into
workbook 2 and assign B to cust# 123. I have about 11,000 entries to do
this for. Any help?


--
Lovelock, David
------------------------------------------------------------------------
Lovelock, David's Profile: http://www.excelforum.com/member.php...fo&userid=2826
View this thread: http://www.excelforum.com/showthread...hreadid=376403