Prev: VLookup between date ranges ?
Next: Need a code
From: Steve on 23 Apr 2010 12:19
Sorry 'bout that. Somehow it got send too early.
Here is my table representing A = Pay Period Week, B = Sat date of week begin.
If I manually enter any date, e.g., 4/8/10, in I need the lookup to produce
the A3, because 4/8 is in that week. 4/10 to produce A4, 4/16 to produce A5,
etc.
Something like if >= B3 but <b4, then A3.

row A B
3 2010082 4/3/10
4 2010091 4/10/10
5 2010092 4/17/10
6 2010101 4/24/10
7 2010102 5/1/10
8 2010111 5/8/10

Thanks,

Steve


 | 
Pages: 1
Prev: VLookup between date ranges ?
Next: Need a code