+ Reply to Thread
Results 1 to 4 of 4

INDEX? IF Any Of These Values Appears in B1, Insert Value in A1

  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2010
    Posts
    50

    INDEX? IF Any Of These Values Appears in B1, Insert Value in A1

    Thanks for taking a look.

    B1 contains a half dozen words. If any of the following words (Wizard, Of, Oz) appears in Cell B1, insert the word in A1.

    Cheerio, and thank you for your help. You all don't get enough credit for helping out dummies, like me. Thanks.

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: INDEX? IF Any Of These Values Appears in B1, Insert Value in A1

    Something like this may work:

    Please Login or Register  to view this content.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    04-29-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: INDEX? IF Any Of These Values Appears in B1, Insert Value in A1

    Thank you. Yes, that works perfectly!! Now, for every additional word I wish to search for, how would I adjust the formula? Because, actually, I have 30 words I need to locate, not just three. I have tried to add another word myself, but...well...no luck.

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: INDEX? IF Any Of These Values Appears in B1, Insert Value in A1

    Using this method, the formula would get pretty large and unruly. May want to look into vba.

+ 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. VBA pop up appears since I insert a row in a document
    By 2mi3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2015, 05:09 PM
  2. [SOLVED] Cannot insert a row in what appears to be a table in a worksheet
    By PH-Texas in forum Excel General
    Replies: 1
    Last Post: 08-01-2013, 02:29 PM
  3. [SOLVED] Insert value if specific word appears in that row
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-15-2012, 02:04 PM
  4. VBA - Index double match and insert values in range
    By Biinge in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-02-2011, 02:43 PM
  5. [SOLVED] i push the fx and stupid insert funtion box appears
    By patrick in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2005, 04:06 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