+ Reply to Thread
Results 1 to 6 of 6

Search value on a string column to retrieve corresponding attribute

  1. 01-05-2018, 01:37 AM #1
    Cleins
    Cleins is offline
    Registered User
    Join Date
    04-12-2011
    Location
    Mexico
    MS-Off Ver
    Excel 2003
    Posts
    10

    Search value on a string column to retrieve corresponding attribute

    Hi Experts
    Happy 2018

    I need your help on an Excel VBA macro that search values from column A into string column C and retrieve the corresponding D value to populate column B (see example below)

    A
    B
    C
    D
    10 Circle - 10 C11 A Circle - 11
    14 Circle - 14 C10 B Circle - 10
    25 Blvd - 25 C14 A Circle - 14
    12 Loop - 12 B21 D Blvd - 21
    58 B25 A Blvd - 25
    28 Loop - 28 L28 B Loop - 28
    L12 C Loop - 12

    Truly appreciated
    Cleins
    Reply With QuoteRegister To Reply
  2. 01-05-2018, 02:47 AM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Search value on a string column to retrieve corresponding attribute

    this can be done via simple formula
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    see file attached to see formula in action
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 01-05-2018, 02:58 AM #3
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,170

    Re: Search value on a string column to retrieve corresponding attribute

    Give this a go...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  4. 01-05-2018, 03:35 PM #4
    Cleins
    Cleins is offline
    Registered User
    Join Date
    04-12-2011
    Location
    Mexico
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Search value on a string column to retrieve corresponding attribute

    Thanks for your quick reply. It works perfect
    That is what I was looking for
    Reply With QuoteRegister To Reply
  5. 01-05-2018, 03:40 PM #5
    Cleins
    Cleins is offline
    Registered User
    Join Date
    04-12-2011
    Location
    Mexico
    MS-Off Ver
    Excel 2003
    Posts
    10

    Re: Search value on a string column to retrieve corresponding attribute

    Thank you Sintek,
    It works and will help me to enhance my VBA knowledge
    Thanks + Regards
    WJ
    Reply With QuoteRegister To Reply
  6. 01-06-2018, 02:22 AM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,170

    Re: Search value on a string column to retrieve corresponding attribute

    Pleasure...Tx for rep +
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search 4 columns of data for a match and retrieve from a 5th column
    By P Hawk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-29-2015, 05:38 PM
  2. [SOLVED] Search for a string and retrieve string from an adjacent cell.
    By djt80 in forum Excel General
    Replies: 5
    Last Post: 01-27-2015, 03:57 PM
  3. Search column for string and date then search adjacent cell and pop up message
    By ftwobtwo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-06-2014, 09:55 AM
  4. I need to search a column for a particular word string and find all rows with that string
    By Grejtak in forum Excel General
    Replies: 1
    Last Post: 09-11-2014, 10:59 AM
  5. [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
  6. Excel 2007 : How to search text string within a column and return search value in adjacent column
    By johannes121 in forum Excel General
    Replies: 1
    Last Post: 07-26-2011, 06:48 AM
  7. how to retrieve a character from a text string in a column?
    By aysrun in forum Excel General
    Replies: 2
    Last Post: 05-27-2009, 12:02 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1