L
Lisa
Sorry, but this site would not let me post a reply to my earlier thread, so I
had to start a new one...
Here is my spreadsheet:
---Date Range---
Conversion Date Descr1 Begin Date End Date Descr
10/25/94 ? 02/05/96 03/03/96 FY1997P1
12/12/94 ? 03/04/96 03/31/96 FY1997P2
10/17/95 ? 04/01/96 04/28/96 FY1997P3
10/31/95 ? 04/29/96 05/26/96 FY1997P4
11/14/95 ? 05/27/96 06/23/96 FY1997P5
Assume Conversion Date is column G, Descr1 = column h, Begin Date is column
j, End Date = column k, and Descr = column l.
I need to 'lookup' the conversion date within the Begin Date and End Date
range, to return the value 'Descr' in the cell under 'Descr1'
I have search the KB and can't seem to find how the 'VLOOKUP' function can
look up a range of dates...anyone's help is greatly appreciated!~
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
A previous response tot he other post said I needed to use the IF
statetment, but I don't see how to use a range to looup the appropriate date
using IF..
Can anyone help me, please?
had to start a new one...
Here is my spreadsheet:
---Date Range---
Conversion Date Descr1 Begin Date End Date Descr
10/25/94 ? 02/05/96 03/03/96 FY1997P1
12/12/94 ? 03/04/96 03/31/96 FY1997P2
10/17/95 ? 04/01/96 04/28/96 FY1997P3
10/31/95 ? 04/29/96 05/26/96 FY1997P4
11/14/95 ? 05/27/96 06/23/96 FY1997P5
Assume Conversion Date is column G, Descr1 = column h, Begin Date is column
j, End Date = column k, and Descr = column l.
I need to 'lookup' the conversion date within the Begin Date and End Date
range, to return the value 'Descr' in the cell under 'Descr1'
I have search the KB and can't seem to find how the 'VLOOKUP' function can
look up a range of dates...anyone's help is greatly appreciated!~
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
A previous response tot he other post said I needed to use the IF
statetment, but I don't see how to use a range to looup the appropriate date
using IF..
Can anyone help me, please?