Results 1 to 8 of 8

LOOKUP with TRUE/FALSE Values

Threaded View

  1. #1
    Registered User
    Join Date
    06-13-2019
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 14.3.9
    Posts
    6

    LOOKUP with TRUE/FALSE Values

    Hello,

    I'm trying to use the LOOKUP function to return the header for the last FALSE in an array. Here is an example of the data set:

    A B C D
    1 2019 2018 2017 2016
    2 TRUE FALSE FALSE TRUE
    3 TRUE FALSE TRUE TRUE
    4 TRUE TRUE FALSE TRUE

    The code I'm using in to find the header for the last FALSE value in the second row is:
    =LOOKUP(FALSE,A2:D2,A1:D1)
    I would expect that for each row, the LOOKUP would function return an error because LOOKUP expects data to be sorted in ascending order, the first entry in the lookup array is TRUE, and it's looking for FALSE, but that's not what happens.

    If the first value in the lookup array is TRUE and the second value is FALSE, the function returns the second value in the results array (in this case, 2018). But, if the first and second lookup values are TRUE (like in the fourth row), the LOOKUP function throws an error.

    Can anyone explain to me what's happening? Is there a formula that will give me the year with the last FALSE in each row (so for the second row, it should be 2017, for the third row 2018, and for the fourth row 2017).

    Thank you!
    Last edited by capthollyshort; 06-14-2019 at 12:02 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Simple TRUE/FALSE lookup needed
    By willm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2018, 01:49 PM
  2. Replies: 3
    Last Post: 08-16-2018, 06:07 AM
  3. [SOLVED] True and False Lookup
    By greatdragon in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-08-2017, 08:03 PM
  4. lookup exact match returns TRUE or FALSE
    By quade_1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2016, 02:21 AM
  5. [SOLVED] formula to lookup formatting and return true false
    By paintballlovr in forum Excel General
    Replies: 2
    Last Post: 05-17-2012, 09:32 AM
  6. lookup value - true/false
    By Peter in forum Excel General
    Replies: 3
    Last Post: 05-01-2006, 07:30 PM
  7. Can LooKUP get return value of True or False?
    By lvcha.gouqizi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2005, 07:30 PM

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