Closed Thread
Results 1 to 2 of 2

using vlookup to move multiple columns of data to receiving table when keys match

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    idaho
    MS-Off Ver
    Excel 2010
    Posts
    4

    using vlookup to move multiple columns of data to receiving table when keys match

    hi, i asked this question yesterday but could not get the provided answer to work; the way i interpret the provided solution was to use vlookup, however, i understand the parameter setup is return only one column/row intersection when keys match; if it will return multiple adjacent columns of data in the same row, please provide an example of how the vlookup will actually look;

    here is the background of the situation and the goal;
    table 1 (its own worksheet) has a record key (several are duplicate keys, there are 75 different keys in the table) in rows a1 thru a350; table 2 (different worksheet) has a record key in a1 thru a75 and data in adjacent cells thru column an; the data elements in each cell within the row are different and particular to that records key; the goal is to move all of the data elements in table 2 to their respective columns in table 1 when record keys match between table 1 and table 2. how can it be done; specific code is appreciated.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: using vlookup to move multiple columns of data to receiving table when keys match

    Hello handball, and welcome to the forum.

    Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

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