Thread: table lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JeffK JeffK is offline
external usenet poster
 
Posts: 53
Default table lookup

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