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