+ Reply to Thread
Results 1 to 2 of 2

Help Needed with IF(S) and ISNUMBER and SEARCH (I think)

  1. 07-09-2021, 12:46 PM #1
    izzy_MCR
    izzy_MCR is offline
    Registered User
    Join Date
    07-09-2021
    Location
    Manila, Philippines
    MS-Off Ver
    Version 16.50
    Posts
    1

    Question Help Needed with IF(S) and ISNUMBER and SEARCH (I think)

    Hi Guys,

    First time to post but I'm literally at the end of my sanity trying to figure out the right formula for what I want created so you guys will be my last help (I've been at it for about 5 hours :'( )

    Basically I need a single formula that will return either a "1" or a "0" based on 3 columns (but each columns have about 4-7 different entries). I tried a combination of IF + ISNUMBER + SEARCH but getting no luck. I've attached the excel that I'm working on if someone could please help me with the formula :'(
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-09-2021, 12:56 PM #2
    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
    28,261

    Re: Help Needed with IF(S) and ISNUMBER and SEARCH (I think)

    Guessing as you did explain what is required:


    =IF(AND(ISNUMBER(SEARCH("*HDD*",F2)),ISNUMBER(SEARCH("Newsletters (internal)",G2)),ISNUMBER(SEARCH("Baguio",H2))),1,0)

    or much simpler

    =IF(AND(LEFT(F2,3)="HDD",G2="Newsletters (internal)",H2="Baguio"),1,0)
    Last edited by JohnTopley; 07-09-2021 at 01:18 PM.
    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. ISNUMBER MATCH not working for CF Help Needed
    By Mr. Ervin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-21-2018, 12:20 PM
  2. [SOLVED] IF-OR-ISNUMBER-Search
    By manangmercy2017 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-26-2017, 12:16 PM
  3. Formula Help Needed: IF plus ISNUMBER plus SEARCH plus OR plus AND
    By TOLJ in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2016, 01:30 AM
  4. [SOLVED] Help with =IF(ISNUMBER(SEARCH
    By micahd in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-03-2016, 01:54 PM
  5. [SOLVED] ISNUMBER and SEARCH
    By jwkathol in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-15-2016, 10:07 PM
  6. If, or, isnumber, search
    By reb2u in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2012, 10:53 AM
  7. ISNUMBER and VLOOKUP Help Needed
    By lrbest4x4xfar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-26-2005, 10:05 AM

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