+ Reply to Thread
Results 1 to 4 of 4

Search Function - how to search for multiple items

  1. #1
    Registered User
    Join Date
    06-30-2018
    Location
    Chicago
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    14

    Lightbulb Search Function - how to search for multiple items

    I have an example excel file attached.

    I have an array formula set up in K3:K6...

    The formula does search (even a partial search) for the text that is in B3 and searches for this text in F1:F26, and then displays the corresponding url from H1:H26. If it finds multiple instances of the searched word it displays multiple corresponding urls.

    How can I modify the formula so that instead of only searching for anything found in B3, the formula will also search for anything in C3, or D3....

    So in the example the formula only searches for "H240" and displays the corresponding url....

    How can I make the formula search for "H240" or "rope" or "black", and display any urls that match either of the three words.

    I think it is something simple, I tried using for a range of cells in the search function but that didn't work. I also tried explicitly placing the 3 words in the formula and that worked, however I would like for it to link to the 3 cells so that it dynamically updates.

    Thank You for your help!
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2502
    Posts
    13,700

    Re: Search Function - how to search for multiple items

    Try changing SEARCH($B$3,$F$1:$F$26) to SEARCH($B$3:$D$3,$F$1:$F$26). That returns 5 urls at my end.
    Dave

  3. #3
    Registered User
    Join Date
    06-30-2018
    Location
    Chicago
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    14

    Re: Search Function - how to search for multiple items

    thank you that worked!

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2502
    Posts
    13,700

    Re: Search Function - how to search for multiple items

    You are welcome. Thank you for the feedback.

    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] Search column items in multiple sheets
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-23-2018, 10:59 AM
  2. Multiple items Search, select, copy and past in new sheet!
    By nitozinho in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-17-2015, 05:33 AM
  3. [SOLVED] Search for Multiple Items and Display Result of Particular Word
    By Ajay_tippu in forum Excel General
    Replies: 1
    Last Post: 06-16-2014, 07:55 PM
  4. [SOLVED] Search within a column and repeat the search until all items are found
    By RANDY LIPOSKY in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-09-2014, 10:23 AM
  5. Replies: 1
    Last Post: 10-18-2012, 05:52 AM
  6. [SOLVED] Using Index and Match to search an array that has multiple items in each cell
    By tdlewis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2012, 08:45 PM
  7. Replies: 2
    Last Post: 02-17-2010, 12:33 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