| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return a value associated with a range of values, e.g. tax rates
Every 6 mos, the interest rate in my model changes. I want Excel to search a
column containing a list of 6-month ranges of dates, such as, 1/1/99 to 6/30/99; next, 7/1/99 to 12/31/99; next 1/1/00 to 6/30/00; next 12/31/00, and so on for several years. Then return the interest rate specified next to the date range within which a particular date specified in another cell falls. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Return a value associated with a range of values, e.g. tax rates
Sounds like a job for VLookup. Good help on this function is availabl in the function wizard Mat -- Mallyca ----------------------------------------------------------------------- Mallycat's Profile: http://www.excelforum.com/member.php...fo&userid=3551 View this thread: http://www.excelforum.com/showthread.php?threadid=55530 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup and return range of values | Excel Worksheet Functions | |||
| Performance Spreadsheet (Rates of Return) | Excel Discussion (Misc queries) | |||
| How do I use LOOKUP to return a range of values, then SUM values? | Excel Worksheet Functions | |||
| how do i return a range of values | Excel Discussion (Misc queries) | |||
| Return range of values on an "IF" statement | Excel Worksheet Functions | |||
Linear Mode
