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.
Bookmarks