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