Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,480
    Thanks
    135
    Thanked 7 Times in 7 Posts

    Vlookup to look up interest %

    I have a table where H1 is ffor month 1-84 , H2 is for months 85-180 & H3 is for months 181-240 and the %'s are to the right of this

    I Col A , I have the month numbers i.e 1 to 240. I woulsd like a formula in Col b to look up the appropriate Int % in the table H1 to I3 based on the month number

    I have attached my spreadsheet your assistance is most appreciated
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,524
    Thanks
    37
    Thanked 67 Times in 63 Posts
    Put this formula in B9 and fill down the B column: =IF(A9<=$H$1,$I$1,IF(A9<=$H$2,$I$2,$I$3))

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,480
    Thanks
    135
    Thanked 7 Times in 7 Posts
    Thanks for the reply, much appreciated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •