+ Reply to Thread
Results 1 to 6 of 6

IF ISTEXT SEARCH OR AND functions

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    Mumbai,India
    MS-Off Ver
    2016
    Posts
    4

    Lightbulb IF ISTEXT SEARCH OR AND functions

    If cell A1 has a value " APPLE COMPUTER" and cell B1 has value" 16" IMAC" cell C1 should find APPLE IN A1 , 16" IN B1 AND RETURN VALUE "SMALL SIZE DESKTOP" if both conditions are matched orelse it should return" NONE" in cell C1

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: IF ISTEXT SEARCH OR AND functions

    Hi
    try this
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Adjust your domain
    See if 16 is text or number " 16" or 16
    If you want 16" you must use the string "16"""
    Last edited by José Augusto; 11-18-2015 at 04:25 AM.

  3. #3
    Registered User
    Join Date
    11-17-2015
    Location
    Mumbai,India
    MS-Off Ver
    2016
    Posts
    4

    Re: IF ISTEXT SEARCH OR AND functions

    Hi,

    it says the formula is not valid and then highlights "small

  4. #4
    Registered User
    Join Date
    11-17-2015
    Location
    Mumbai,India
    MS-Off Ver
    2016
    Posts
    4

    Re: IF ISTEXT SEARCH OR AND functions

    attachment
    Attached Images Attached Images

  5. #5
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: IF ISTEXT SEARCH OR AND functions

    Hi
    You can use 16" this way
    =IF(SUMPRODUCT(--(A2:A7=" APPLE"),--(B2:B7=" 16"""))>0," SMALL SIZE"," NONE")

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Regards

  6. #6
    Registered User
    Join Date
    11-17-2015
    Location
    Mumbai,India
    MS-Off Ver
    2016
    Posts
    4

    Re: IF ISTEXT SEARCH OR AND functions

    hi the result is none but it should display small size!

+ 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-ISTEXT-SEARCH, to return values from multiple cells
    By CClio333 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-21-2013, 05:10 PM
  2. ISTEXT or SEARCH function with 2 variables
    By mobycane in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2010, 04:49 AM
  3. Replies: 6
    Last Post: 07-01-2010, 04:13 AM
  4. search functions
    By iain hamilton in forum Excel General
    Replies: 6
    Last Post: 04-21-2008, 05:18 PM
  5. Can ISTEXT search a range
    By mike4545 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-09-2007, 05:44 PM
  6. Using ISTEXT to search the same column
    By mike4545 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-25-2007, 12:24 AM
  7. search & if functions
    By sys-con in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-17-2007, 12:02 PM
  8. How can I nest ISTEXT and IF functions?
    By Hyatt2k2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2006, 03:55 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