+ Reply to Thread
Results 1 to 6 of 6

If, ISNUMBER, SEARCH Question! Help!

  1. #1
    Registered User
    Join Date
    08-08-2014
    Location
    NY
    MS-Off Ver
    2016
    Posts
    12

    Angry If, ISNUMBER, SEARCH Question! Help!

    Hello everyone!

    Had a question. I am trying to create a formula that allows me to search for MULTIPLE specific text within a column and have it spit out the appropriate information: Here is my issue.
    Col A Col B
    Size Zone
    160x600 MBT-Mortgage-160x600
    MBT_BankDeals-300x600
    MBT_Banking-300x250

    What I am trying to do is create an if statement that will look for the size within Column B (Zone) and spit out the appropriate size! I attempted to create it with the following formula:
    =IF(ISNUMBER(SEARCH("160x600",E2)),"160x600", "Neither")

    The problem is this only helps me locate ONE of the sizes (160x600). I need the formula to be able to identify all three sizes at the same time!(300x250,300x600) Is it a matter of using the OR statement within the IF formula?

    Please help!!

    M

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: If, ISNUMBER, SEARCH Question! Help!

    =IFERROR(LOOKUP(2,1/ISNUMBER(SEARCH({"160x600";"300x250";"300x600"},E2)),{"160x600";"300x250";"300x600"}),"NEITHER")

    OR

    Please Login or Register  to view this content.
    Last edited by daffodil11; 08-08-2014 at 12:31 PM. Reason: OPTIONS
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    08-08-2014
    Location
    NY
    MS-Off Ver
    2016
    Posts
    12

    Re: If, ISNUMBER, SEARCH Question! Help!

    DAFFODIL11 For the WIN!!! Thank you so much!!!

    Now if I wanted to add more values to that formula (i tried and it didnt work), what do I need to do?

    For example, in addition to the three I listed above I need to add : 728x90 and 300x50.

    I tried to mimic the other sizes but for some reason it did not work!

    Thanks again!!!!

    M

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: If, ISNUMBER, SEARCH Question! Help!

    The first of the two formulas is probably easier to adjust. Just put a semicolon and quotes between each, and then list it again in the second half.

    =IFERROR(LOOKUP(2,1/ISNUMBER(SEARCH({"160x600";"300x250";"300x600";"728x90";"300x50"},E2)),{"160x600";"300x250";"300x600";"728x90";"300x50"}),"NEITHER")

    And here's the 2nd:

    Please Login or Register  to view this content.
    Last edited by daffodil11; 08-08-2014 at 12:45 PM.

  5. #5
    Registered User
    Join Date
    08-08-2014
    Location
    NY
    MS-Off Ver
    2016
    Posts
    12

    Re: If, ISNUMBER, SEARCH Question! Help!

    THANK YOU SO MUCH!! You saved me!

    I would buy you a shot if I could!!!

    M

  6. #6
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: If, ISNUMBER, SEARCH Question! Help!

    I'll have one tonight in my honor.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. 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. [SOLVED] if(isnumber(search(not this text?)
    By wizadele14 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-19-2013, 08:02 AM
  2. If, or, isnumber, search
    By reb2u in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2012, 10:53 AM
  3. Isnumber(search
    By AVIDDA in forum Excel General
    Replies: 1
    Last Post: 01-14-2011, 02:45 PM
  4. If(isnumber(search question
    By Wskip49 in forum Excel General
    Replies: 2
    Last Post: 12-02-2009, 02:14 PM
  5. ISNUMBER(SEARCH Function
    By somesoldiers in forum Excel General
    Replies: 2
    Last Post: 07-14-2009, 10:49 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