+ Reply to Thread
Results 1 to 3 of 3

Pass vlookup response to a string and concantenate

  1. #1
    Registered User
    Join Date
    03-05-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    2

    Pass vlookup response to a string and concantenate

    Hi

    I have worked out what I need to do, but really dont know how to do it.

    In sheet 1 I have a ID number in Col A, I need a macro to pick up the ID number and run a vlookup in sheet 2 for the ID number (col A) and then pass the value in col D to a sting and then continue down the sheet for X rows concantenating all the values from col D (with the correct ID in col A) to the string. Once finished it would paste the string into sheet1 Col B and then pick up the next value in sheet 1 Col A and do the same until it reaches the bottom.

    I know I am asking a lot, especially as I have no code to show where I am coming from but I cant find anything in google and I can record a macro and edit....

    Thanks

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: Pass vlookup response to a string and concantenate

    Do you have some sample data that you can attach?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Pass vlookup response to a string and concantenate

    Have a look at the VLOOKUPALL function in the workbook attached to this thread: http://www.eileenslounge.com/viewtopic.php?f=27&t=3287
    Good luck.

+ 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