+ Reply to Thread
Results 1 to 3 of 3

Looking for explanation for LOOKUP parameters like 7^7, 8^8, 9^9

Hybrid View

  1. #1
    Registered User
    Join Date
    11-12-2014
    Location
    Munich, Germany
    MS-Off Ver
    2016
    Posts
    9

    Looking for explanation for LOOKUP parameters like 7^7, 8^8, 9^9

    Hi,

    I use a LOOKUP(9^9,... to pick the last cell with a value in a row, but somebody just gave me this parameter, but I couldn't find anything explaining these.
    I tried also 7^7, 8^8, which seem to do the same thing. Others like 1^1, 2^2,... don't seem to work.

    Any ideas?

    Thanks
    xingo

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,079

    Re: Looking for explanation for LOOKUP parameters like 7^7, 8^8, 9^9

    You need just to put big enough number that will never be reached.

    So if you have numbers in column like: 1,2,4,5,3,6,4,3,5,6,... then 10 is enough...
    But if you get number 11 then it wont work.

    So you can put 100.
    Etc...

    If you have dates then 100 won't be enough either.

    So instead of think what is biggest number you can get you can put biggest number in excel: 9.99999999999999E+307

    If you are lazy, like me, then you can write 99^99 that is quite big: 3,68E+197

    I DON'T suggest to use 9^9 since it's "small" number. Only 387420489

    espetially not smaller...

    1^1 is just 1 and it will always fail (unles you use negative numbers). Even percentage between 0 and 1 can sometimes has 1 and return unexpected result.
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    11-12-2014
    Location
    Munich, Germany
    MS-Off Ver
    2016
    Posts
    9

    Re: Looking for explanation for LOOKUP parameters like 7^7, 8^8, 9^9

    Hi zbor,

    now I got it. Easy thing, was just thinking far too complicated. ;-)
    9^9 works for us in this case, as it is picking revenue numbers and we are not in hundreds of millions (yet) :-D.

    Thanks a lot!
    xingo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA explanation
    By extremis in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 08-09-2013, 10:33 AM
  2. VBA explanation
    By Darel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2011, 02:00 AM
  3. Formula with multiple lookup parameters
    By h0mer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-11-2009, 11:08 AM
  4. Lookup using 2 parameters
    By jacknjob in forum Excel General
    Replies: 1
    Last Post: 05-11-2007, 02:29 PM
  5. LOOKUP but with 2 parameters ?
    By Maileen in forum Excel General
    Replies: 1
    Last Post: 02-22-2006, 01:55 PM

Tags for this Thread

Bookmarks

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