Here's the problem:

I have several worksheets, split out by month, with a list of dates, a description and a value.

A1 A2 A3
1/13/2005 Bill1 ?Value
1/15/2005 Bill2 ?Value
1/15/2005 Bill3 ?Value

Etc.

In another worksheet I have a list a bills, their value, and the date range for which they are valid

Bill Name StartDate EndDate Value
Bill1 1/1/2005 2/28/2005 $100.00
Bill1 3/1/2005 4/30/2005 $90.00
Bill2 1/1/2005 12/31/2005 $50.00
Bill3 1/1/2005 6/30/2005 $100.00
Bill3 7/1/2005 12/31/2005 $75.00

What I need to do is find the value of bill x (A2) in the worksheet with the list of bills, date ranges and values, based on the date value in A1 so that column A3 can be populated with the result.

Any help would be greatly appreciated.


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-