Finding multiple items from a list

C

Col

Hello all,

Wonder if you kind souls can help me out with this one.
The office mangers in my territory need to complete some information for me
and I'm trying to make that operation as easy as possible. One of which is
automatically populating a particular sheet with their office staff details
from another sheet containing details of all the staff in the company.

If the data layout is similar to below;

Office no OfficeName Forename Surname
4 Manchester Name Name
4 Manchester Name Name
4 Manchester Name Name
5 Leeds Name Name
5 Leeds Name Name

How can I bring across multiple lines and use a formula so when the office
manager at Manchester for example inputs a '4' in A1 the names of only his
staff appear underneath.
I use Index/Match regularly without problems but now I'm stumped as it's
dealing with multiple lines or info.

Many thanks for any advice,


Colin.
 
T

T. Valko

Will the data *always* be sorted or grouped by the office number as is shown
in your sample data?
 
C

Col

Indeed, thank you very much.

I did actaully solve it by writing a very long formula compirisng
CELL/MID/INDEX/MATCH/INDIRECT but yours is much better.

Thank you.

Colin.
 

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

inserting data from a list 1
Creating a list from an existing list. 1
to pull from multiple sheets-index,match,vlookup,if,and,or??? 10
result of selecting from the dropdown list should be a dropdown list 1
Rename Multiple Sheets from a List of Available Names 5
Display top 5 items from a list with matching criteria? 8
Vlookup or something more? Trying to make the book intuitive... 7
multiple select from the drop down list in excel. list in one sheet and drop down in 5

Top