+ Reply to Thread
Results 1 to 8 of 8

Find First Instance of Word and Copy to Cell Depending on Other Cell Value

  1. #1
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    MS365 Subscription Excel for Mac
    Posts
    1,017

    Find First Instance of Word and Copy to Cell Depending on Other Cell Value

    On Sheet1 I want to find the first instance of one of these four words exactly (Big, Small, Fat, Thin) in Column B only. Once found, it needs to look two cells directly to the right of where it is found and if the cell equals what's in C1 then paste the letter "H" and the number directly to the left of where the word is found into sheet3 cell A3. It also needs to know that if two cells directly to the right of where it is found equals what's in cell D1 then paste the letter "A" and the number directly to the left of where the word is found also into sheet3 cell A3.

  2. #2
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    855

    Re: Find First Instance of Word and Copy to Cell Depending on Other Cell Value

    niceee... ! Is there a priority of the searched terms ? Or whatever comes first ? (smallest found row)
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you

  3. #3
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    MS365 Subscription Excel for Mac
    Posts
    1,017

    Re: Find First Instance of Word and Copy to Cell Depending on Other Cell Value

    Quote Originally Posted by bulina2k View Post
    niceee... ! Is there a priority of the searched terms ? Or whatever comes first ? (smallest found row)
    Whatever comes first!

  4. #4
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    21,025

    Re: Find First Instance of Word and Copy to Cell Depending on Other Cell Value

    Something like this
    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    855

    Re: Find First Instance of Word and Copy to Cell Depending on Other Cell Value

    here is my piece of code:
    Please Login or Register  to view this content.

    I can't help but notice a resemblance with your post from the other day, but you'll see that my code uses another method for the goal.

  6. #6
    Valued Forum Contributor
    Join Date
    03-03-2009
    Location
    UK
    MS-Off Ver
    MS365 Subscription Excel for Mac
    Posts
    1,017

    Re: Find First Instance of Word and Copy to Cell Depending on Other Cell Value

    Solved. Excellent jindon!

  7. #7
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    21,025

    Re: Find First Instance of Word and Copy to Cell Depending on Other Cell Value

    You are welcome and thanks for the rep.

  8. #8
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    855

    Re: Find First Instance of Word and Copy to Cell Depending on Other Cell Value

    Thank you for the rep also ScabbyDog.
    Last edited by bulina2k; 01-25-2016 at 09:05 AM.

+ 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] Find the first instance of a value, and return the value of the cell next to it.
    By timmtamm in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-27-2015, 05:08 AM
  2. [SOLVED] Macro to find specific word in cell and then copy and paste the adjacent cell upwards
    By raytej82 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2014, 05:33 PM
  3. Replies: 8
    Last Post: 11-04-2013, 02:34 PM
  4. copy a cell multiple times depending on cell value starting on a specific cell
    By weritadiojomiel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2013, 05:25 AM
  5. Find word in one cell and copy cell above in other column
    By kurtwagner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2012, 08:31 AM
  6. Need to find a word in a cell, copy the entire cell and two adjacent columns on same row
    By hang_sandwich in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2012, 11:16 AM
  7. Find word in column and copy cell to the right
    By dariushou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2008, 05:40 PM

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