+ Reply to Thread
Results 1 to 4 of 4

Formula needed to: Find/Search for words and copy them into another worksheet (dynamic)

  1. #1
    Registered User
    Join Date
    08-16-2014
    Location
    london
    MS-Off Ver
    2007
    Posts
    4

    Exclamation Formula needed to: Find/Search for words and copy them into another worksheet (dynamic)

    Hi, I'm looking for a formula to search one column (first column, A, in Worksheet 1) for a keyword (just one word) and then paste the results (which the formula automatically updates when that keyword is added/removed from cells in the column) along a Row in another worksheet (Worksheet 3 and Worksheet 4).

    The keywords for each formula to reference will be in individual cells in Worksheet 2 in Columns A (for the formula in Worksheet 3) and B (for the formula in Worksheet 4). Hopefully the order of the keywords in Worksheet 2 will match the order in Worksheet 3 so I can just drag the formula down and it references each new keyword.

    I have close to zero formula knowledge so please make the solution paint-by-numbers/layman terms, thanks a lot!

    Any questions please ask, sample file attached, thanks!
    Attached Files Attached Files
    Last edited by titaniumapple; 04-03-2020 at 11:00 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Formula needed to: Find/Search for words and copy them into another worksheet (dynamic

    Please read the yellow banner at the top of this page.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-16-2014
    Location
    london
    MS-Off Ver
    2007
    Posts
    4

    Re: Formula needed to: Find/Search for words and copy them into another worksheet (dynamic

    Quote Originally Posted by alansidman View Post
    Please read the yellow banner at the top of this page.
    Ok got it thanks, just uploaded the sample file

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,423

    Re: Formula needed to: Find/Search for words and copy them into another worksheet (dynamic

    Try pasting the following into cell B2 of both the business and personal sheets and then copying down and across:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 18
    Last Post: 05-15-2018, 05:17 AM
  2. [SOLVED] Formula for : two values to find in another sheet this words and copy the hole cell
    By AndreHeFu in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-12-2017, 12:38 PM
  3. [SOLVED] Formula Help for Array Word Search to find key words and put in adjacent cell
    By tains in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-25-2017, 06:36 PM
  4. Search/Find for multiple words stored in an array for a worksheet
    By freshie1001 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2016, 06:00 AM
  5. Formula needed to search data then copy into different cell if found
    By Lizebb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2016, 11:03 AM
  6. Replies: 1
    Last Post: 04-04-2012, 07:15 PM
  7. Search Dynamic words within Column
    By bayatmu in forum Excel General
    Replies: 3
    Last Post: 03-20-2012, 04:52 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