+ Reply to Thread
Results 1 to 2 of 2

"If cell populated, and matches, then outcome" query???

Hybrid View

millerchris "If cell populated, and... 11-25-2014, 07:44 AM
samba_ravi Re: "If cell populated, and... 11-25-2014, 07:55 AM
  1. 11-25-2014, 07:44 AM #1
    millerchris is offline
    Registered User
    Join Date
    11-25-2014
    Location
    Glasgow, Scotland
    MS-Off Ver
    2007
    Posts
    3

    "If cell populated, and matches, then outcome" query???

    Hello, im looking for help with the following problem:

    If column J is populated with a value AND this value matches column I, column K needs to say “Yes”. If column J is not populated with a value, column K must remain blank.

    excel clip jpg.JPG
    Reply With QuoteRegister To Reply
  2. 11-25-2014, 07:55 AM #2
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,937

    Re: "If cell populated, and matches, then outcome" query???

    =if(J3="","",IF(J3=I3,"Yes","No")
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If "6343" in cell A3 matches "monthly" in B3 show a "Y" in C3
    By laaxy in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-05-2014, 07:38 PM
  2. [SOLVED] Hide "#N/A" in Vlookup cell when data val list is not populated
    By carlandtina02 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2013, 11:37 AM
  3. [SOLVED] INDEX MATCH formula that matches "*W3" or "*,3" and displays multiple matches in array
    By bkwins in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-11-2013, 12:46 AM
  4. [SOLVED] Highlight or place "X" when cell matches any other cell within the entire workbook.
    By Mr.Atlantis in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-28-2013, 12:34 PM
  5. If cell X matches a value in a cell range, return "specific text" - HELP :(
    By paulandrewlee in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-02-2013, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1