+ Reply to Thread
Results 1 to 7 of 7

True and False Lookup

  1. #1
    Registered User
    Join Date
    11-30-2012
    Location
    Argentina
    MS-Off Ver
    Excel 2016
    Posts
    13

    Question True and False Lookup

    Hello,
    I Have this sheet (let's call it "charsheet")

    Please Login or Register  to view this content.
    And I have other sheet (let's call it "answersheet") where I have

    Please Login or Register  to view this content.
    I want to do a search that gives true or false when the animal match the characteristic detailed in "charsheet". For example, for above sheet the result should be:

    Please Login or Register  to view this content.
    Can anyone help me with this formula?

    Thanks!

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: True and False Lookup

    can you attach a sample file with the format you like? It's not practical to expect someone to build it for you.
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: True and False Lookup

    Assuming those tables begin in A1 of each sheet and they include a header row, like A1="Animal", B1="Characteristic"

    On answersheet, in C2
    =COUNTIF(INDEX(charsheet!$B$2:$D$7,MATCH(A2,charsheet!$A$2:$A$7,0),0),B2)>0

  4. #4
    Registered User
    Join Date
    11-30-2012
    Location
    Argentina
    MS-Off Ver
    Excel 2016
    Posts
    13

    Re: True and False Lookup

    Sorry, please find the attached example.

    Thanks.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-30-2012
    Location
    Argentina
    MS-Off Ver
    Excel 2016
    Posts
    13

    Re: True and False Lookup

    Thank you very much! This worked perfectly!!

  6. #6
    Forum Contributor
    Join Date
    12-13-2013
    Location
    Calgary,AB,Canada
    MS-Off Ver
    2016,O365
    Posts
    236

    Re: True and False Lookup

    "answersheet"

    D2=ISNUMBER(MATCH(B2,OFFSET(charsheet!$A$2,MATCH(A2,charsheet!$A$3:$A$8,),1,1,3),))

  7. #7
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: True and False Lookup

    You’re welcome

+ 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. 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
  2. [SOLVED] Help! 1 - Lookup specific text from column E and insert true/false - IF
    By KClem in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-06-2015, 06:38 PM
  3. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  4. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  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. [SOLVED] lookup value - true/false
    By Peter in forum Excel General
    Replies: 3
    Last Post: 05-01-2006, 07:30 PM
  7. [SOLVED] 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

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