+ Reply to Thread
Results 1 to 4 of 4

Formula to check list value the return corresponding column info

  1. #1
    Registered User
    Join Date
    12-05-2012
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    6

    Formula to check list value the return corresponding column info

    Hi guys,
    I am stuck with a formula to calculate the following example:

    Column a Column b
    Item 1 1
    Item 2 0
    Item 3 1
    Item 4 1
    Etc

    Column a contains text description, column b will only contain a 1 or a 0. I would like display in column c all text descriptions from column a if column b is equal to 1.
    Thanks in advance

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Formula to check list value the return corresponding column info

    hi neilwilson. maybe:
    =IF(B1=1,A1,"")

    or
    =IF(B1,A1,"")

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Formula to check list value the return corresponding column info

    Please Login or Register  to view this content.
    like that?

  4. #4
    Registered User
    Join Date
    12-05-2012
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Formula to check list value the return corresponding column info

    Thanks for the response, maybe my example was a bit to simple.
    Let me explain my actual situation. I have multiple sheets with capability data for machines. For each machine there are value for quality checks, if the value is <1.33 I return a 1 if not I return a 0 (into the next adjacent column) I have a list with hundreds of quality checks and I would like on the first sheet to look at all sheets and any value that is a 1 then to return the name of quality check. Hope that makes sense. I'm guessing that some kind of index formula maybe required?

+ 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] Formula to Return List of Results that contain a match in a column
    By Shadefalcon in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-17-2013, 05:10 PM
  2. [SOLVED] Formula to check LAST CELL in column containing one of the names in a list
    By chiidzzz in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 01-05-2013, 01:11 PM
  3. [SOLVED] Formula to check pre-defined list and show relevant info
    By galvinpaddy in forum Excel General
    Replies: 5
    Last Post: 07-05-2012, 02:43 AM
  4. edit macro that is pasting info to check column for duplicate info
    By roth_nj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2009, 05:55 PM
  5. formula for converting info in a column into a list...
    By TheShatner in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2007, 02:15 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