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?
 

"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.