LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup more than one value across a table Dee Excel Worksheet Functions 4 May 20th 09 02:23 PM
Table lookup Richard[_2_] Excel Worksheet Functions 3 October 30th 08 08:55 AM
Lookup data in a variable table & retrieve data from a pivot table Shawna Excel Worksheet Functions 3 October 10th 08 11:11 PM
Pivot table doing a lookup without using the lookup function? NGASGELI Excel Discussion (Misc queries) 0 August 2nd 05 05:08 AM
lookup a value on a table Gaby L. Excel Worksheet Functions 1 June 30th 05 07:48 PM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"