Vlookup Function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yan - 12 Jun 2007 00:06 GMT

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?

Reply to this Message

Bob Phillips - 12 Jun 2007 00:23 GMT

Same as I gave you yesterday.

Signature

HTH

Bob

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

>I am trying to do some lookup, to gett all males stats and female stats,
>that
[quoted text clipped - 19 lines]
>
> Can you help?

Reply to this Message

Yan - 12 Jun 2007 00:51 GMT

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

Don't know why?

> Same as I gave you yesterday.
>
[quoted text clipped - 21 lines]
> >
> > Can you help?

Reply to this Message

Bob Phillips - 12 Jun 2007 08:40 GMT

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

Signature

HTH

Bob

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

> The one you gave me yesterday, for some reason does not work!
>
[quoted text clipped - 26 lines]
>> >
>> > Can you help?

Reply to this Message

Roger Govier - 12 Jun 2007 12:34 GMT

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.

Signature

Regards

Roger Govier

>I am trying to do some lookup, to gett all males stats and female
>stats, that
[quoted text clipped - 19 lines]
>
> Can you help?

Reply to this Message