LOOKUP BETWEEN 2 DATES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 dob>8/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)
 
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?
 
Try it and see.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Have you looked at the help on Vlookup to understand its behavior with
reference to the 4th argument? Recommend you do.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Test if a date falls within a given range of dates in Excel? 6
UDF for Aging in excel - Help needed 15
Date function help needed 3
Assign Values Based on First Record in Group 2
Function for grouping range of data 1
query based question..... null value? 4
Date of Birth Conversion to Age 1
Query that will aggregate a group 5

Back
Top