+ Reply to Thread
Results 1 to 4 of 4

Multiple Search

Hybrid View

  1. 05-02-2018, 10:12 AM #1
    Phuocam
    Phuocam is offline
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,176

    Re: Multiple Search

    or change NOT(ISERR()) to ISNUMBER():

    =IF(SUMPRODUCT(--ISNUMBER(SEARCH($A$1:$A$3,C1)))>0,"1",IF(SUMPRODUCT(--ISNUMBER(SEARCH($B$1:$B$3,C1)))>0,"2",""))
    Reply With QuoteRegister To Reply
  2. 05-07-2018, 03:25 AM #2
    i82
    i82 is offline
    Forum Contributor
    Join Date
    09-05-2012
    Location
    ukraine
    MS-Off Ver
    Excel 2007
    Posts
    141

    Re: Multiple Search

    Thanks. Solved
    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. [SOLVED] Search multiple worksheets for search term and paste results in a summary sheet
    By Andy15 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 04-03-2017, 01:49 PM
  2. Windows Search - Multiple Excel Files - Checked Box Search
    By sirolk99 in forum Excel General
    Replies: 2
    Last Post: 02-21-2017, 04:14 PM
  3. Create User form to perform search using multiple search criteria
    By cherias in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2015, 06:16 AM
  4. Search multiple columns for with multiple input for search and return all results
    By sdl2 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-22-2014, 08:47 AM
  5. Creating Multiple search tool (currently single criteria search) and reporting to Main Pag
    By Gluv1983 in forum Excel General
    Replies: 4
    Last Post: 05-20-2014, 10:03 AM
  6. Truncate text strings using LEFT and FIND/SEARCH for multiple search terms
    By ngdoherty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2013, 07:51 PM
  7. Search Multiple Worksheets Against List of Non-Exact Search Criteria?
    By thump4r in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2010, 03:46 PM

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