Results 1 to 5 of 5

Thread: V Look Up Formula Not Working

  1. #1

    V Look Up Formula Not Working



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Workbook2.xlsx

    Hello,

    I am having trouble getting my V Look up formula to work when the amounts are the same but when the numbers are not part of a formula the V Look up formula works. I wasn't able to figure it out and i was hoping someone might be able to figure out why it is not working.

    I have attached the document to this thread so you can take a look at it.

    Please let me know if anyone has any questions.

    Thank you,

    Jwelk

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by Jwelker12 View Post
    Workbook2.xlsxPlease let me know if anyone has any questions.
    VLOOKUP returns the error if "lookup_value" does not exist
    In cell A21 there is the number 1, the number 1 does not exist in "table_array"

    In cell A15 you have the result of a formula 1.95107913669065
    In cell B15 you have the result of a formula 1.95107913669065

    In cells E15 and cell F15 you have the number 1.951079137
    Last edited by navic; 2015-07-17 at 07:15 AM.
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3

    Ranking Error

    Helo Navic,

    The main issue I'm having is why A17 & A18 are not showing the same ranking as E17 & E18 because if they calculated the same then I would not have the errors in B21 & C21.

    It doesnt make sense to me why E17 & E18 would work but A17 & A18 would not work when they are the same numbers?

    Any ideas?

    Thanks

    Jwelk

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by Jwelker12 View Post
    Any ideas?
    If you can help, use ROUND formula with 9 digit in cells A15 and B15
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  5. #5
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    102
    Articles
    0
    Excel Version
    365
    Hi,

    Weirdly, there are some “imprecise” results in Excel.

    You can understand why these matter exist in Excel here : https://support.microsoft.com/en-en/kb/78113

    The solution is, as advised by Navic, to round the result of your calculations.

    Good luck

Posting Permissions

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