Hello,

Here is my spreadsheet:
Col A Col B Col C
08/01/06 10/01/06 2,500
11/01/06 10/01/16 8,000

Column A = Start Date
Column B = End Date
Column C = Dollar Amount

I have a range of dates in Column F - they are all dates that start with the
first of the month. So basically, if one of those dates in Column F fall
within a date range (between column A and B) it needs to return the value
from column C.

Example, if a date in Column F is 09/01/06 - it should return the value of
2,500.
Example 2 - if the date is 02/01/10 - the value it should return is 8,000.

I completely appreciate any help that you can provide.
THANKS!
Rob

=LOOKUP(F1,A1:A2,C1:C2)

That's for the two rows you have.. extend the 2 to however many rows you
have...
Copy that formula down the list, and you should have it, as long as the
start date is in ascending order. End date is not needed...



"Rob" wrote:

Hello,

Here is my spreadsheet:
Col A Col B Col C
08/01/06 10/01/06 2,500
11/01/06 10/01/16 8,000

Column A = Start Date
Column B = End Date
Column C = Dollar Amount

I have a range of dates in Column F - they are all dates that start with the
first of the month. So basically, if one of those dates in Column F fall
within a date range (between column A and B) it needs to return the value
from column C.

Example, if a date in Column F is 09/01/06 - it should return the value of
2,500.
Example 2 - if the date is 02/01/10 - the value it should return is 8,000.

I completely appreciate any help that you can provide.
THANKS!
Rob

You could also try this formula:

=IF(IF(F3=A3,OR(F3<=B3)),C3,"Date Out of Range")
--
T Tipsy


"Rob" wrote:

Hello,

Here is my spreadsheet:
Col A Col B Col C
08/01/06 10/01/06 2,500
11/01/06 10/01/16 8,000

Column A = Start Date
Column B = End Date
Column C = Dollar Amount

I have a range of dates in Column F - they are all dates that start with the
first of the month. So basically, if one of those dates in Column F fall
within a date range (between column A and B) it needs to return the value
from column C.

Example, if a date in Column F is 09/01/06 - it should return the value of
2,500.
Example 2 - if the date is 02/01/10 - the value it should return is 8,000.

I completely appreciate any help that you can provide.
THANKS!
Rob