+ 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
    MS-Off Ver
    MS Office 2019
    Posts
    18,513

    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.

  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 2010/2019
    Posts
    10,714

    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