Vlookup Function?

[Yan]

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?

 

[Bob Phillips]

Same as I gave you yesterday.

--
HTH

Bob

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

 

[Yan]

The one you gave me yesterday, for some reason does not work!

Don't know why?

 

[Bob Phillips]

We need a bit more info if you want some help to sort it.

--
HTH

Bob

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

 

[Roger Govier]

Hi

One way
Apply an Autofilter to your header row.
Filter for Male
Select the visible rows by marking their row numbers and copy to a new
location on your worksheet.
Delete the visible rows

You now have 2 distinct sets of data upon which to perform your
statistics.