+ Reply to Thread
Page 2 of 2 FirstFirst 1 2
Results 16 to 17 of 17

Error when calculating formula with LOOKUP

  1. #16
    Forum Moderator AliGW's Avatar
    Join Date
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)

    Re: Error when calculating formula with LOOKUP

    What exactly is your formula supposed to be doing and in what way is it incorrect? Tell us what results you are expecting and why.

    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  2. #17
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007

    Re: Error when calculating formula with LOOKUP

    lookup() is empty because I am too lazy to type out all of the references inside each time. Replace the empty lookup() placeholder with the full LOOKUP() function as you have it in your current C3 formula.

    Moving all of the unknowns to one side is usually one of the first steps to solving any algebra problem. If I am solving 3x=6+x, then my first step is to move all of the x's to one side 3x-x=6+x-x which makes 2x=6 and x=3. Again, if you need to refresh your algebra skill, I recommend some time with an algebra tutorial: https://www.purplemath.com/modules/solvelin3.htm
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread
Page 2 of 2 FirstFirst 1 2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1