Merging data between worksheets using reference index?

L

ler01kjh

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

Guest

ler01kjh said:
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging data between worksheets using reference index? 1
PARSING DATA TO SHEETS 3
Populate a userform from a worksheet 1
Look Up 2 Values, Match 2 Values Different Tab Return 3rd Value 4
Look up match and highlight 1
Auto hyperlink between sheets by same number - maybe macro? 1
Transferring data between worksheets 1
Excel A CountIF question... I think 2

Top