Debra deserves the thanks.

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"soph" wrote in message
...
Thanks RD, this was great!

"Ragdyer" wrote:

This can be accomplished using formulas, although a Pivot Table would be
the
recommended way to go.

Debra Dalgleish has a web site with an extensive number of pages
dedicated
to Pivot tables.

http://www.contextures.com/tiptech.html

Scroll down to the P's, and at the end, there's a page with an intro to
Pivots.

If you still would want a formula, post back with a description of your
datalist configuration.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"soph" wrote in message
...
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