Return a value associated with a range of values, e.g. tax rates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Sounds like a job for VLookup. Good help on this function is availabl
in the function wizard

Mat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer array element offset value to a matched value 3
Supressing a #VALUE! error returned? 3
Shapes in 2010 1
Mileage Rates 7
Change "Text Like" to "Greater than" 3
MATCH NUMBER From another wooksheet Macro 1
The Road- Matching data within a range of values 1
Add Hours by Looping through Data Q 27

Back
Top