How to fill the matched field automatically

[SJ Hong]

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

 

[Rowan Drummond]

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

 

[topola]

SJ Hong napisal(a):

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

In Sheet2 select your data range and name this range "DATA".
In Sheet1 cell B3 formula = VLOOKUP($A3,data,2,0). For details while
being in the cell with formula select Insert > Function.

Tomek Polak
http://vba.blog.onet.pl