+ Reply to Thread
Results 1 to 6 of 6

Macro to vlookup and insert results in initial with brackets

  1. #1
    Registered User
    Join Date
    02-10-2012
    Location
    Penang, Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    25

    Macro to vlookup and insert results in initial with brackets

    Dear Gurus,

    Please help me with this macro to vlookup and insert the results eg. (K) for Korry at the whereused column as shown in the attachment. I have more than 1000++ to manually do this. Please help.

    Rgds,
    Catherine
    Attached Files Attached Files
    Last edited by cathchin; 01-13-2013 at 08:41 PM.

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Macro to vlookup and insert results in initial with brackets

    Catherine,

    Its not clear as how your making the match. Im guessing Columns A,B,C and D on the results sheet will have data in them. Then you want to separate the values in Column C by ; and lookup the values in the Data sheet. So lookup 200-08108-9020-119 on the data sheet, find the match and make 200-08108-9020-119 = 200-08108-9020-119(K) and add Korry Esterline to column E and repeat for the rest of the values in column C. Is that correct?
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Registered User
    Join Date
    02-10-2012
    Location
    Penang, Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: Macro to vlookup and insert results in initial with brackets

    Hi Mike,

    Yes you are right on " lookup 200-08108-9020-119 on the data sheet, find the match and make 200-08108-9020-119 = 200-08108-9020-119(K)". I do not need a macro for " add Korry Esterline to column E "

    I only need for column C. Please help.

    Thank you,
    Catherine

  4. #4
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Macro to vlookup and insert results in initial with brackets

    So will the names already be in column E? If so we can just use them to add the (K) ,(O) and (P) instead of having to look them up.

  5. #5
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,519

    Re: Macro to vlookup and insert results in initial with brackets

    Give this a try

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    02-10-2012
    Location
    Penang, Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    25

    Re: Macro to vlookup and insert results in initial with brackets

    Hi Mike,

    The macro works like magic! I only change the below and it works well
    aArr = .Range("a2").CurrentRegion

    Thanks a million!
    Catherine

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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