An easy way is just to apply a filter to the appropriate column.

Hope this helps.

Pete

On Mar 10, 2:54*pm, JPDS wrote:
I have a list of staff in sheet 1, along with where they work in the company
i.e. their geographic location, their department name, their section and
their team name etc.

How do I use a Vlookup to show me all the names of staff from the list who
are in 'x' department and/or 'y' team name?

Thanks