Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
This should be easy - Part 2
Sorry, I wasn't able to post a reply to my earlier theread, so I had to start
a new topic... 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 replay to the above mentioned using and IF statement, but I don't know how to use that function with a range of dates to look up. Can any one please help me? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
This should be easy - Part 2
Here's my reply to your original post:
Based on your posted sample there are *no* conversion dates that fall within the begin date - end date. Let's assume that your first conversion date is 4/23/1996 This array formula** will return FY1997P3: =INDEX(L2:L6,MATCH(1,(G2=J2:J6)*(G2<=K2:K6),0)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER) -- Biff Microsoft Excel MVP "Lisa" wrote in message ... Sorry, I wasn't able to post a reply to my earlier theread, so I had to start a new topic... 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 replay to the above mentioned using and IF statement, but I don't know how to use that function with a range of dates to look up. Can any one please help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Should be easy but....... | Excel Discussion (Misc queries) | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
Copying Part of a row down part of a column | Excel Discussion (Misc queries) | |||
new user with easy question? not easy for me | New Users to Excel | |||
Is there an easy way to do this? | Excel Worksheet Functions |