Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Thanked 0 Times in 0 Posts

    Vlookup problem (Excel 2003)

    I have a mystery that has me really perplexed. I am trying to subtract 2 percentages. The result of that formula will be used in a Vlookup formula. The results I get are strange, in that if I change a variable in the subtraction calculation the new result (which does appear in the Vlookup table) does NOT return a value yet an error.

    My only thought is that it is formatting; however, I have created new files, and have changed formats several times trying to dissect this problem.

    I have attached a very good example of this. By changing cell A13 (red) to anything but 8 or 10 will not bring back the right results.

    Can anyone help me with this mystery?
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Vlookup problem (Excel 2003)

    It's due to very small rounding errors, causing the difference to be not exactly 0,04 equal to the values in B4:B8. If you use the formula


    in C13, the VLOOKUP will work OK.

Posting Permissions

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