Hi

I have 2 questions:

1. Can I use a vlookup to return all of the results rather than just one at
a time? I need to find all of the staff associated with a particular manager
out of a list.
2. Team sizes can vary so in order to return all of the staff member's names
I need to first manually count how many staff are in the team. Can I use a
formula to return all results for a lookup regardless of the number or do I
need to use a macro to do this?

Cheers
Soph