League age chart

[Brian Kolonia]

I have a large number of youth base ball players listed in a roster;

Player name birth date
john doe 3/5/2001
mike smith 7/31/2001...

And an age eligiblality chart on another sheet:
Month
League Age
5 6 7 8 9 10 11 12 1 2 3
4
2002 2002 2002 2002 2002 2002 2002 2003 2003 2003 2003 2003 5
2001 2001 2001 2001 2001 2001 2001 2001 2002 2002 2002 2002 6
2000 2000 2000 2000 2000 2000 2000 2000 2001 2001 2001 2001 7
1999 1999 1999 1999 1999 1999 1999 1999 2000 2000 2000 2000 8
1998 1998 1998 1998 1998 1998 1998 1998 1999 1999 1999 1999 9
1997 1997 1997 1997 1997 1997 1997 1997 1998 1998 1998 1998 10
1996 1996 1996 1996 1996 1996 1996 1996 1997 1997 1997 1997 11
1995 1995 1995 1995 1995 1995 1995 1995 1996 1996 1996 1996 12
1994 1994 1994 1994 1994 1994 1994 1994 1995 1995 1995 1995 13
1993 1993 1993 1993 1993 1993 1993 1993 1994 1994 1994 1994 14
1992 1992 1992 1992 1992 1992 1992 1992 1993 1993 1993 1993 15
1991 1991 1991 1991 1991 1991 1991 1991 1992 1992 1992 1992 16
1990 1990 1990 1990 1990 1990 1990 1990 1991 1991 1991 1991 17
1989 1989 1989 1989 1989 1989 1989 1989 1990 1990 1990 1990 18

I would like to add a colum that would automaticaly grab the correct age
from the chart :
Palyer name birth date leauge age
john doe 3/5/2001 ?
mike smith 7/31/2001 ?

Is this easily done?
Thank you BJK

 

[Bob Phillips]

Assuming that table is in A1:M15, then

=INDEX(M1:M15,MATCH(YEAR(player_birth_date),INDEX(A1:L15,0,MATCH(MONTH(player_birth_date),A1:L1,0)),0))

--
---
HTH

Bob


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

 

[Brad]

Looking at this it appears that the chart is really unimportant - it appears
that the age is based on how old the child is on May 1st.

If this is true

In a helper cell - enter the date 5/1/2007 (say cell e1)
assuming the birthday is in d2....d2000
in cell e2 enter the equation =datedif(d2,$e$1,"y")

HTH;

 

[Brian Kolonia]

Bob, thanks for the response but the chart is on another sheet (sheet 5) How
do I incorporate that into the eq.
-Brian

 

[Brian Kolonia]

Sorry Bob, I had a brain fart, it just clickled now and I was able to get it
to work. Thank you for the help