Vlookup using dates in the lookup range

[hmteacher]

I am trying to use dates in a vlookup table and then looking up its value.
For example I have a date range from 01-01-07 to 01-28-07 and the value to be
looked up is 01, the next range is 01-29-07 to 02-25-07, and value 02, the
next range is 02-26-07 to 04-01-07, value is 3. However, when I have the
vlookup look at the date 03-26-07 it shows the value as 02. Anyone know what
I am doing wrong. The table is
01/01/07 AP017
01/28/07 AP017
02/25/07 AP027
04/01/07 AP037

 

[Tyro]

You need to show us the formula you are using. Important detail!

Tyro

 

[Max]

Think you just need to re-define your ascending sort vlookup table like this

1-Jan-07 AP017
29-Jan-07 AP027
26-Feb-07 AP037
1-Apr-07 AP047
....

then your vlookup* on the date: 26-Mar-07
will return the correct: AP037

*example in E1: =VLOOKUP(D1,A:B,2,TRUE)
where D1 contains the lookup date
and the lookup table is in cols A and B

 

[hmteacher]

I found the problem. I needed to use the start date of the date range. I
was using the end date of the date range.

Thanks for the input.

 

[hmteacher]

I found the problem. I needed to use the start date of the date range. I
was using the end date of the date range.

Thanks for the input.

 

[Max]

Glad you got it sorted out over there.
Thanks for feeding back.