Gimi,

you can use the formula "Vlookup" in colume c and then convert whole raw c
into values. otherwise if you send this file to someone else, it'll not work,
if the link of workbook a is not accesseble to that person.

"Gemi" wrote:

I have two workbooks, one worksheet in each.
Workbook one contains customer data A1:K362 Column C is blank and is where
I need to enter the cutomers fgt acct numbers which are in workbook two.
ColA ColB ColC ColD ColE
Cust# FgtCarrier FgtAcct# CustName CustAdd

Workbook two contains two columns A1:B570
ColA ColB
Cust# FgtAcct#

ColA from both worksheets contain the customer numbers, although not all
customers are listed on the worksheet in workbook one. I need to fill in ColB
with the fgt account numbers. Rather than manually going through both lists
to match up customer acct. and then enter the corresponding fgt. number I am
hoping there is another way. If the cust numbers in ColA match on both
worksheets than enter the fgt acct number for the corresponding cust. acct
(located in ColB on workbook2) in ColC on workbook 1.

Thank you

Lee