Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a 3 Column Table: Begin Date, End Date, Interest. On a separate
worksheet, if a user enters the a specified Begin and End dates, below the entry,I want to list that portion of the table that falls between the dates. (assume the table is A2-C8) Begin Date End Date Interest 1-Jan 5-Feb 2.00% 6-Feb 15-Mar 2.25% 16-Mar 4-Apr 2.50%* 5-Apr 21-Apr 2.25% 22-Apr 1-Jun 2.50% 2-Jun 7-Jul 2.75%* 8-Jul 15-Aug 3.00% Input page Begin Date = Mar 19 End = June 6 16-Mar 4-Apr 2.50% 5-Apr 21-Apr 2.25% 22-Apr 1-Jun 2.50% 2-Jun 7-Jul 2.75% I appreciate your help on this one |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup more than one value across a table | Excel Worksheet Functions | |||
Table lookup | Excel Worksheet Functions | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
lookup a value on a table | Excel Worksheet Functions |