Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to return week number from date? | Excel Worksheet Functions | |||
How to return week number from date? | Excel Worksheet Functions | |||
return previous date from list | Excel Worksheet Functions | |||
How to return a value between date ranges | Excel Worksheet Functions | |||
Drop down list to return row number? | Excel Discussion (Misc queries) |