Return a number from a list of date ranges
 

Hello,

I have looked and looked and I am now stumped. Help!

I want a percentage rate to populate into a cell based on a date entered in
another cell.

Example info:

07/01/87 - 12/31/94 = 12%
01/01/95 - 12/31/95 = 8%
01/01/96 - 12/31/96 = 10%

Date cell A1
Percentage rate cell A2

I type 02/01/95 into cell A1. I would like 8% to populate into cell A2.

Thanks!

Return a number from a list of date ranges
 

Create a lookup table similar to the one below:
Col AA Col BB
07/01/87 12%
01/01/95 8%
01/01/96 10%

Then use a vlookup function to return your percentage. In the table above,
all dates from 07/01/87 to 12/31/94 get 12%, all dates from 01/01/95 to
12/31/95 get 8% and all dates 01/01/96 and beyond get 10%

In A2 the formula would be as follows:

=VLOOKUP(A1,AA1:BB3,2)

Where A1 has the value you're looking up, AA1:BB3 is the location of the
lookup table and 2 is the column that has the return value.
--
Kevin Backmann


"SamanthaG" wrote:

Hello,

I have looked and looked and I am now stumped. Help!

I want a percentage rate to populate into a cell based on a date entered in
another cell.

Example info:

07/01/87 - 12/31/94 = 12%
01/01/95 - 12/31/95 = 8%
01/01/96 - 12/31/96 = 10%

Date cell A1
Percentage rate cell A2

I type 02/01/95 into cell A1. I would like 8% to populate into cell A2.

Thanks!