+ Reply to Thread
Results 1 to 4 of 4

Checking text in cells against a list of possible words

  1. #1
    Registered User
    Join Date
    06-24-2013
    Location
    manchester, england
    MS-Off Ver
    Excel 2003
    Posts
    2

    Checking text in cells against a list of possible words

    I'm trying to make a game where from a choice of 16 words the contestant has to choose four of those words that, when another word is placed before or after each word it makes a phrase.

    e.g From this list of 16 words
    albert
    bell
    bottle
    chariot
    fidler
    hermit
    lambeth
    london
    moon
    print
    shore
    spider
    stocking
    tower
    velvet
    walton

    choosing bell, bottle, print, stocking can all have BLUE placed before them to make bluebottle, blueprint etc. That would be the correct answer.
    Choosing their four words would be from a drop down list of all 16 words, separate cell for each list options/chosen answer.
    bell bottle print stocking CORRECT

    There would be 4 rows in total for 4 different answers to be made from the 16 words on offer. I have tried everything to get it to work in the 5th cell but it's driving me mad. Can anyone help please ?

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,844

    Re: Checking text in cells against a list of possible words

    If you post a workbook with what you got so far it is easier for someone to get started helping you.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Checking text in cells against a list of possible words

    I agree with Jacc (Go Advanced>Manage Attachments). Do you have a sheet with all possible correct permutations? (i.e. blue moon could replace any of those words you chose) Do you indicate the rule before choosing from the dropdowns? and how specific is the rule? ("choose 4 words which can have BLUE placed before them?" or "Choose 4 words which can have the same word placed before them")
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    06-24-2013
    Location
    manchester, england
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Checking text in cells against a list of possible words

    connect.xls

    Thanks for the help so far. File attached. The rule is "Choose 4 words which can have the same word placed before them"

+ 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. Replies: 1
    Last Post: 04-04-2012, 07:15 PM
  2. Checking cells for 2 text strings
    By Phillycheese5 in forum Excel General
    Replies: 4
    Last Post: 10-04-2010, 10:25 AM
  3. Checking multiple cells for text.
    By matt20687 in forum Excel General
    Replies: 5
    Last Post: 07-16-2010, 06:55 PM
  4. Checking two cells for text, returning one value
    By sdaddy in forum Excel General
    Replies: 4
    Last Post: 06-09-2009, 02:49 AM
  5. Checking text across a range of cells
    By thebluemask in forum Excel General
    Replies: 4
    Last Post: 10-09-2008, 06:34 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