+ Reply to Thread
Results 1 to 4 of 4

Need formula to enter specific text if a column contains other specific text

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Need formula to enter specific text if a column contains other specific text

    I am creating a small database where the first tab lists a series of documents that will be reviewed in one column (Jones1, Jones 2, etc.) and presents a summary status. If the document meets certain parameters, an entry will be made on a second sheet containing relevant data from that document by the reviewer, and the reviewer will enter the document name (Jones1) in a corresponding column. If it doesn't meet the parameters, there will be no corresponding entry on the second sheet. I basically need a formula to populate a column in the summary spreadsheet with a "Y" or "N" depending on whether that doc name appears in the corresponding column.

    I am an absolute novice when it comes to formulas, so I hope my question makes sense. Appreciate any help!
    Last edited by sugarmags74; 12-04-2012 at 02:24 PM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,310

    Re: Need formula to enter specific text if a column contains other specific text

    If both tabs list the documents in column A starting in row 2 (assuming you have a row of headers) then put this formula in the desired column in row 2 of the summary sheet and copy down:

    =IF(ISERROR(MATCH(A2,Sheet2!A:A,0)),"N","Y")

    A2 is the cell containing the document name in the summary sheet, and Sheet2!A:A is column A containing the document names in the second sheet. Replace "Sheet2" with the actual name of the second sheet.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    12-03-2012
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Need formula to enter specific text if a column contains other specific text

    Thank you so much - I adjusted the formula to correspond to different columns to account for the order I set it up in, but it worked perfectly. Always wonderful to learn something new!

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,310

    Re: Need formula to enter specific text if a column contains other specific text

    You're very welcome! Glad it worked for you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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