+ Reply to Thread
Results 1 to 3 of 3

Help to modify formula so that combinations of search terms are used

  1. #1
    Registered User
    Join Date
    11-09-2009
    Location
    Shropshire UK
    MS-Off Ver
    Excel 365
    Posts
    38

    Question Help to modify formula so that combinations of search terms are used

    Hi.

    I have a formula which looks for keywords in one cell, compares to a list on another sheet and then returns a string from another list. This was created by a forum user on this thread 1254914

    The problem I'm having is that the keywords can show up in cells that are not appropriate (eg 'Flash' should only refer to the DC Character, but the cell relating to David Bowie's 'Flash' logo is also included).

    So how can I change the search to look for combinations of keywords? So 'flash' is only accepted if the cell also contains 'DC Comics'?

    I've attached a sample of the sheet for clarity.
    Attached Files Attached Files

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Help to modify formula so that combinations of search terms are used

    wouldn't you just change you search terms -- i.e. A29 changes from Flash to DC Comics*Flash

    incidentally, you can change your Array Entry requirement to standard by switching approach slightly, e.g.:

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


    EDIT:

    if you need to search multiple terms, i.e. Flash could appear pre DC Comics... you can add a 2nd column of terms -- then append the above with an additional SEARCH test

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by XLent; 01-11-2019 at 08:18 AM.

  3. #3
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Northumberland, UK
    MS-Off Ver
    various
    Posts
    2,704

    Re: Help to modify formula so that combinations of search terms are used

    sorry - I missed fact that you had seemingly already configured the EDIT piece... so using your sample file as-provided your non-Array entry formula would be:

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

+ 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] Please help to.modify the code to Possible 7/1-49 Lottery Number Combinations
    By Isaacliu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-08-2016, 11:52 AM
  2. Modify this Search Formula to search across a range of cells
    By zicitron in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-16-2013, 08:11 AM
  3. [SOLVED] Macro/s to create Search Bar to filter to search terms entered activated by Command Button
    By JasonRay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2013, 03:44 PM
  4. 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
  5. [SOLVED] Match search terms, and add data in next column. Multi search problem.
    By Wales MB in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-23-2013, 06:10 PM
  6. Modify Combinations Code
    By rhudgins in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-02-2010, 11:03 AM
  7. Two search category & two search terms
    By avk in forum Excel General
    Replies: 3
    Last Post: 05-17-2010, 02:32 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