+ Reply to Thread
Results 1 to 4 of 4

IF(AND(NOT(SEARCH( <> replace with a simpler IFS statement

  1. #1
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    105

    IF(AND(NOT(SEARCH( <> replace with a simpler IFS statement

    Hello,

    taking over a workbook for someone and I am trying to simplify their formula. Attached

    From what I see, these are using a nest IF(AND(OR(NOT with search and ISNUMBER

    I do not know that all of these are needed. Essentially, I would like to consolidate all columns (X-AB) to one nested IFS statement in column W.

    From what I can see the the variables with change, so need a IFS that supports multiple outputs.

    I started and IFS to test it out on the attached.

    On Excel 2016
    Attached Files Attached Files

  2. #2
    Cheeky Forum Moderator Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: IF(AND(NOT(SEARCH( <> replace with a simpler IFS statement

    Here's an approach for the Col_X formulas.
    - Create these 3 named ranges on a different tab
    Name: List01
    Please Login or Register  to view this content.
    Name: List02
    Please Login or Register  to view this content.
    Name: List03
    Please Login or Register  to view this content.
    Then put use this regular formula, copied down:
    Please Login or Register  to view this content.
    Try that approach for the other columns.

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,937

    Re: IF(AND(NOT(SEARCH( <> replace with a simpler IFS statement



    You are using IFS in the sample. That only works in Office 365. Your profile shows 2013. What version(s) will this have to work in?
    Dave

  4. #4
    Forum Contributor
    Join Date
    02-13-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    105

    Re: IF(AND(NOT(SEARCH( <> replace with a simpler IFS statement

    Hi Ron Coderre , Is there anyways I can use the IFS for this? Where I have the IFS return multiple different results?

    @FlameRetired I am now on office 2016. I updated my profile to reflect that now. Thanks

+ 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. If statement? Or Replace?
    By Jayfaas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2015, 10:25 AM
  2. [SOLVED] Can You Put An IF Statement Inside a REPLACE Statement?
    By nevi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2014, 07:34 AM
  3. Help joining an if statement with a search statement
    By Segurde in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-09-2014, 03:13 PM
  4. Replies: 0
    Last Post: 09-29-2013, 04:50 AM
  5. Simpler formula for IF statement?
    By Glayva in forum Excel General
    Replies: 1
    Last Post: 08-03-2011, 12:03 PM
  6. IF STATEMENT - must be a simpler way
    By tlapointe1970 in forum Excel General
    Replies: 1
    Last Post: 07-26-2011, 05:01 PM
  7. [SOLVED] Limit Search & Replace's Replace All?
    By Bob@1800-mail.com in forum Excel General
    Replies: 4
    Last Post: 08-03-2006, 02:00 PM

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