+ Reply to Thread
Results 1 to 5 of 5

Conditional if in Excel Function

  1. 05-18-2021, 10:13 AM #1
    mailtoashok13
    mailtoashok13 is offline
    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.
    Reply With QuoteRegister To Reply
  2. 05-18-2021, 10:36 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,082

    Re: Conditional if in Excel Function

    Maybe
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    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

    Reply With QuoteRegister To Reply
  3. 05-18-2021, 10:36 AM #3
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,707

    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"))
    Reply With QuoteRegister To Reply
  4. 05-18-2021, 10:50 AM #4
    mailtoashok13
    mailtoashok13 is offline
    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
    Reply With QuoteRegister To Reply
  5. 05-18-2021, 10:58 AM #5
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,082

    Re: Conditional if in Excel Function

    Ok, try:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    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. [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. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1