Merging data between worksheets using reference index?
 

I'm not sure whether my query is similar to others, but I hope someone
can point me in the right direction.

I have an excel file with two worksheets. On both are a list of branch
numbers in the first column. I want excel to match the branch number
from the first sheet to the second and import a column of data from
the second (column c).
Not all branch numbers present in the second sheet appear in the
first.

Be grateful if someone could give me some simple direction - tried to
look at some excel websites and totally confused by them!
Thanks.

Merging data between worksheets using reference index?
 

One way via INDEX/MATCH

In Sheet1,
Branch numbers running in A2 down

Place in B2:
=IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",INDEX(Sheet2!C :C,MATCH(A2,Sheet2!A:A,0)))
Copy B2 down as far as required. This will return what you seek, ie Sheet2's
col C values for the branch numbers in col A which match with those in
Sheet2's col A. Unmatched branch numbers, if any, will return blanks: "".
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"ler01kjh" wrote:
I'm not sure whether my query is similar to others, but I hope someone
can point me in the right direction.

I have an excel file with two worksheets. On both are a list of branch
numbers in the first column. I want excel to match the branch number
from the first sheet to the second and import a column of data from
the second (column c).
Not all branch numbers present in the second sheet appear in the
first.

Be grateful if someone could give me some simple direction - tried to
look at some excel websites and totally confused by them!
Thanks.