using relative reference from 1 worksheet to another

[handball]

hi, there are 2 worksheets (excel 2010)....the source worksheet contains multiple rows of data; each row has 20+ columns of info that relate to the row key, which is in column a,b, and c of that row;
the goal is to use a simple relative reference that can be used to associate with a row's key; then have the row's data from the source worksheet appear in the receiving worksheet if the row key matches; what is an easy/quick way to get this done?

[Ace_XL]

pPerhaps, a vlookup or an INDEX/MATCH combo
Make sure you dont have absolute referncing by removing the $ signs for easy copy/paste

[handball]

hi and thanks for the response; the receiving key is concatenated in one cell and i dont want to take the time to concatenate the key in the source a,b,c, cells; i dont mind doing a 'manual' approach as the nbr of rows in the source work sheet is less than 100 and this is a relatively static worksheet (few additions/deletions of row keys in 1-year). i recall something about using a 'name' reference that may be useful, but in looking over examples of its use, it wasnt clear to me on its appropriatness; comments please.

[handball]

hi, i asked this question recently 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; after reading and reviewing examples of index/match, i missed out this combination of functions would provide the answer; if this combinaton of parameters will return multiple adjacent columns of data in the same row when keys match, please provide an example of how the functions 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 and are in sequence by this key) 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.