Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,421
    Thanks
    124
    Thanked 5 Times in 5 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,470
    Thanks
    30
    Thanked 62 Times in 58 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,421
    Thanks
    124
    Thanked 5 Times in 5 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
  •