Same as I gave you yesterday.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Yan" wrote in message
...
I am trying to do some lookup, to gett all males stats and female stats,
that
are in 10 different group...

EX:

Team 1

Female France Bigras 3 - 985 - 256
and so on...

and

Male - Mike Fisher 3 1200 - 450
and so on...

I try the Vlookup function, but it only comes back with the first result,
i
have about 30 mens and 30 womens, a i need to get all result one under
each
other in a different sheet...

Can you help?