Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,568
    Thanks
    141
    Thanked 12 Times in 12 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
    Silver Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,607
    Thanks
    45
    Thanked 77 Times in 72 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,568
    Thanks
    141
    Thanked 12 Times in 12 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
  •