+ Reply to Thread
Results 1 to 5 of 5

Conditional if in Excel Function

  1. #1
    Registered User
    Join Date
    05-04-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    37

    Conditional if in Excel Function

    How to write condition in below formula that if Column A is not present in Column C of Sheet1 it should show "No Data"

    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,416

    Re: Conditional if in Excel Function

    Maybe
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,769

    Re: Conditional if in Excel Function

    This ??

    =IF($A2="","No Data",IF(ISNUMBER(SEARCH(INDEX(Sheet1!$N$2:$N$205,MATCH($A2,Sheet1!$C$2:$C$205,0)),$K2,1)),"Match","NoMatch"))

  4. #4
    Registered User
    Join Date
    05-04-2021
    Location
    India
    MS-Off Ver
    2019
    Posts
    37

    Re: Conditional if in Excel Function

    There will be value in A2 cell but its not present in C2 cell then i have to show No Data

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,416

    Re: Conditional if in Excel Function

    Ok, try:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

+ 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] help with conditional sum function
    By dragosnb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-16-2013, 11:05 AM
  2. [SOLVED] Conditional formatting using now() function Excel 2003
    By mtouhig in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2013, 10:06 AM
  3. [SOLVED] Excel lookup function or conditional formula?
    By atlpersonnel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2012, 04:37 AM
  4. Excel Conditional Formatting with If function
    By spursrule68 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2012, 06:24 AM
  5. Conditional Min function
    By mitelkm in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2008, 12:23 PM
  6. conditional MIN() function
    By markx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-23-2006, 06:25 AM
  7. [SOLVED] inserting a conditional "go to" command on a excel "if" function
    By velasques in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2006, 04:20 PM
  8. How do I set up a conditional function in Excel
    By Kamsa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-13-2005, 11:05 AM

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