+ Reply to Thread
Results 1 to 4 of 4

IF(ISNUMBER(SEARCH Fromula from multiple cells not working

  1. #1
    Registered User
    Join Date
    11-15-2016
    Location
    Ohio
    MS-Off Ver
    2010
    Posts
    4

    IF(ISNUMBER(SEARCH Fromula from multiple cells not working

    Could some one please help why this formula is not working

    Formula: =IF(ISNUMBER(SEARCH("Pre-Application",B1,)),IF(ISNUMBER(SEARCH("Lighting",B2)),Lists!A35))

    What I am trying to do is create a checklist that displays documentation needed based on when a Pre-Application or Final Application is submitted to my job. In addition there are certain measures they can apply for in those applications. So for Example if a Pre-Application with only lighting is applied for, I can pick both of those options. Application Type being it's own dropdown menu located in cell B1. While Measures where lighting can be selected, is a dropdown located in cell B2. The list that populates if both are selected is located in a separate tab named "Lists" and the list starts at A35.

    So far the formula listed above only states false even though both Pre-Application and Lighting are selected. I am able to enter separate formulas one for Application Type and one for Measures, but I really need them to be combined so one relies on the other in order to populate.

    If anyone could help I would greatly appreciate it!!

    Thanks!!

  2. #2
    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
    27,998

    Re: IF(ISNUMBER(SEARCH Fromula from multiple cells not working

    The formula worked for me, returning the value in A35 of "Lists".

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Registered User
    Join Date
    11-15-2016
    Location
    Ohio
    MS-Off Ver
    2010
    Posts
    4

    Re: IF(ISNUMBER(SEARCH Fromula from multiple cells not working

    I think I attached a sample of the worksheet that I am working on (The Manage Attachment window allowed me to upload the workbook but there was no button to submit). My main goal of this workbook is so that the user can select from the Application Type and Measures, and based on what they choose, only those needed documents show up. Currently the simple Application type documentation works the way I wanted it. However the other documentation in cells A12-A49 and E-12-E49, are only based off the options given in cell B2. The main goal is for the documentation to rely on what is chosen in B1 AND B2.

    Please let me know if this is possible or if you have any advice.

    Appreciate all the help!
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: IF(ISNUMBER(SEARCH Fromula from multiple cells not working

    I think that the reason the formula is not working is because of the extra comma behind B1 i.e.
    =IF(ISNUMBER(SEARCH("Pre-Application",B1,)),IF(ISNUMBER(SEARCH("Lighting",B2)),Lists!A35))
    When I removed the extra comma from a similar formula in MS!A12 of the file attached to post #3 it yielded the result 'HVAC Base' which would be as I would expect.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] My =IF(ISNUMBER(SEARCH Formula is Not Working
    By thanhie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-03-2022, 12:30 AM
  2. =if(isnumber(search( for multiple cells
    By etaussig in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-17-2016, 02:52 PM
  3. [SOLVED] multiple ISNUMBER search
    By frustrated in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-08-2016, 10:09 AM
  4. Multiple IF ISNUMBER SEARCH
    By kalivc in forum Excel General
    Replies: 0
    Last Post: 01-21-2015, 08:23 PM
  5. [SOLVED] Multiple IF(ISNUMBER(SEARCH...), need sum
    By Imtall62 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-12-2014, 11:41 AM
  6. Replies: 14
    Last Post: 06-17-2013, 09:43 AM
  7. Multiple IF ISNUMBER SEARCH
    By bibach in forum Excel General
    Replies: 5
    Last Post: 07-13-2011, 04:41 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1