Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Vlookup on a percentages, as opposed to a word/text

    Hello... I have a vlookup formula (see attached) that is not showing the correct result. I'm looking up a percentage. I've used vlookup's for years, and have never had this problem. Apparently I haven't been looking up a "percentage"... usually I'm looking up a word (text). Can anyone tell me why this is not working, and how I can get it to work. Any help is much appreciated.
    Thanks!
    Lana
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Try this in D7 and copy down.....
    =ROUND(D6+$D$2,4)

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Ankeny, Iowa, USA
    Posts
    344
    Thanks
    8
    Thanked 0 Times in 0 Posts
    Of course! Rounding... now I feel really dumb. I round everything else in my worksheets, but I falied to do so in this table! Thanks so much for opening my eyes tfspry! I must have been sleeping!
    Lana

  4. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Lana - You are very welcome. Thanks for posting back!

Posting Permissions

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