Picking a date from a range of dates

[jgroetsch]

Hi all I am new to the list so please be patient with me.

I have a list of birthdays in colum J I have a list of dates in a range ex:

N O P
U10 8/1/1997 7/31/1998
U11 8/1/1996 7/31/1997

I need to return the correct code in column N based on the date in column J. I have tried all the sugestions on the list but could not find the exact example I am trying to accomplish.

Any help would be greatly apprecrated!

 

[Smitty]

Welcome to the Board!

I'm not entirely clear what you want, but this may be a start:

Book2
	N	O	P	Q
1	Code #	Date 1	Date 2
2	U10	8/1/1997	7/31/1998
3	U11	8/1/1996	7/31/1997
4
5
6	Lookup Date	Code #
7	7/31/1998	U10
Sheet1

Hope that helps,

Smtty

 

[jgroetsch]

N/A returned

I tried this formula but did not work, this might show what I am trying to do better.

J K L M N
11/5/1995 #N/A U10 8/1/1997 7/31/1998
7/25/1996 U11 8/1/1996 7/31/1997
12/2/1994 U12 8/1/1995 7/31/1996
1/9/1995 U13 8/1/1994 7/31/1995
1/13/1997 U14 8/1/1993 7/31/1993

I need j1 to return the code U12

=INDEX(L2:L6,MATCH(J2,M2:N6,0),0)