I have a sports roster to keep up to date. I need to always have the kids
current age bracket updated. How can I return an age group based on their
dob? The problem is there are 9 age groups and excel won't let me do that
many nested if statements. It would be something like this
the first age group range would be: if dob8/1/98 & dob < 7/31/99 then age
group = u8
name dob age group
john smith 7/1/00 ??

Create a table of values like so

Age Group
01/08/1998 1
31/07/1999 2

etc.

in say H1:I10

and then use

=VLOOKUP(B2,H1:I10,2,TRUE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

" Pivot Table/Query" wrote
in message ...
I have a sports roster to keep up to date. I need to always have the kids
current age bracket updated. How can I return an age group based on their
dob? The problem is there are 9 age groups and excel won't let me do that
many nested if statements. It would be something like this
the first age group range would be: if dob8/1/98 & dob < 7/31/99 then age
group = u8
name dob age group
john smith 7/1/00 ??

How exactly would that work since their dob has to be in between those 2
dates in order to be in the next age group?

"Bob Phillips" wrote:

Create a table of values like so

Age Group
01/08/1998 1
31/07/1999 2

etc.

in say H1:I10

and then use

=VLOOKUP(B2,H1:I10,2,TRUE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

" Pivot Table/Query" wrote
in message ...
I have a sports roster to keep up to date. I need to always have the kids
current age bracket updated. How can I return an age group based on their
dob? The problem is there are 9 age groups and excel won't let me do that
many nested if statements. It would be something like this
the first age group range would be: if dob8/1/98 & dob < 7/31/99 then age
group = u8
name dob age group
john smith 7/1/00 ??

Try it and see.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

" Pivot Table/Query" wrote
in message ...
How exactly would that work since their dob has to be in between those 2
dates in order to be in the next age group?

"Bob Phillips" wrote:

Create a table of values like so

Age Group
01/08/1998 1
31/07/1999 2

etc.

in say H1:I10

and then use

=VLOOKUP(B2,H1:I10,2,TRUE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

" Pivot Table/Query"
wrote
in message ...
I have a sports roster to keep up to date. I need to always have the
kids
current age bracket updated. How can I return an age group based on
their
dob? The problem is there are 9 age groups and excel won't let me do
that
many nested if statements. It would be something like this
the first age group range would be: if dob8/1/98 & dob < 7/31/99 then
age
group = u8
name dob age group
john smith 7/1/00 ??

Have you looked at the help on Vlookup to understand its behavior with
reference to the 4th argument? Recommend you do.

--
Regards,
Tom Ogilvy


" Pivot Table/Query" wrote
in message ...
How exactly would that work since their dob has to be in between those 2
dates in order to be in the next age group?

"Bob Phillips" wrote:

Create a table of values like so

Age Group
01/08/1998 1
31/07/1999 2

etc.

in say H1:I10

and then use

=VLOOKUP(B2,H1:I10,2,TRUE)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

" Pivot Table/Query"
wrote
in message ...
I have a sports roster to keep up to date. I need to always have the
kids
current age bracket updated. How can I return an age group based on
their
dob? The problem is there are 9 age groups and excel won't let me do
that
many nested if statements. It would be something like this
the first age group range would be: if dob8/1/98 & dob < 7/31/99 then
age
group = u8
name dob age group
john smith 7/1/00 ??