Use the VLOOKUP formula eg
=VLOOKUP(A2,Sheet2!$A$2:$D$20,2,0)
See excel help and http://www.contextures.com/xlFunctions02.html for
more information.

Hope this helps
Rowan

SJ Hong wrote:
I have following work data.

1. Sheet1

Company code Company name Products Amounts ......
--------------------------------------------------------
aa ZZZ $1,000
ab XXX $900
ca ZZZ $800
dd VVV $1,000
aa XXX $800
.
.
.


2. Sheet2
Company code Company name
--------------------------------
aa ABC Corp.
ab TS Elec.
ca CC Mech.
dd NJ Corp.
.
.
.

As you can see, the company name field is blank. Is there any proper formula
if company code is same between sheet1 and sheet2, company name is filled
automatically in Sheet1?
I would like to know a proper formula in the company name field of Sheet1.


Thanks in advance
SJ Hong