Results 1 to 8 of 8

search for string, return adjacent value

Threaded View

georgiabrown search for string, return... 07-11-2018, 05:43 PM
FDibbins Re: search for string, return... 07-11-2018, 05:47 PM
georgiabrown Re: search for string, return... 07-11-2018, 06:12 PM
FDibbins Re: search for string, return... 07-11-2018, 06:13 PM
georgiabrown Re: search for string, return... 07-12-2018, 05:19 AM
AliGW Re: search for string, return... 07-12-2018, 05:26 AM
AliGW Re: search for string, return... 07-12-2018, 05:47 AM
AliGW Re: search for string, return... 07-12-2018, 09:01 AM
  1. #1
    Registered User
    Join Date
    09-14-2012
    Location
    Coldstream Victoria Australia
    MS-Off Ver
    Microsoft Excel for Mac Version 16
    Posts
    21

    Cool search for string, return adjacent value

    I have a database covered to Excel with 10,000 records.
    Part of the database includes a cell called description

    In this cell there includes a reference to Musicians, as well as lots of other data not relevant to the search

    I want to search each cell for the word Musicians, and put the information immediately following musicians, (maybe 100 characters), into the adjacent cell. This would be the cell where the formula is located

    Any help please

    Ross
    Last edited by FDibbins; 07-11-2018 at 05:45 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Script to Search for a specific String then return cell values above that String-3
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2015, 01:50 PM
  2. [SOLVED] Script to Search for a specific String then return cell values above that String-2
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2015, 01:00 PM
  3. [SOLVED] Script to Search for a specific String then return cell values above that String
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2015, 11:28 AM
  4. [SOLVED] Vlookup, Match (Search or Find) partial string within string in a Cell
    By dluhut in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-28-2013, 12:40 PM
  5. Replies: 1
    Last Post: 09-20-2012, 03:22 PM
  6. [SOLVED] Search for string across header row, then search for another string down found column
    By TucsonJack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2012, 02:09 PM
  7. search a string withing a string : find / search hangs
    By itarnak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2005, 11:05 AM

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