LOOKUP BETWEEN 2 DATES
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 ??
|