Match Cell Then Copy Alternate to Next Blank Cell

Here's my situation:

I have a list in sheet 1 column A that contains names. Sheet 1 column B contains averages. Sheet 2 will be a historical repository of names & averages.

Here's what I need:

Match name from column A on sheet 1 to sheet 2 column A. If it finds an exact match, it pastes the average from sheet 1 coulmn B in to the first open cell in the corresponding row on sheet 2.

I need this to do about 150 all at 1 button click.

Any ideas? Ask if further clarification is required.

Hello kingsolo,

In these 2 columns, is the matching one to one, or can a value appear once in one column and 2 or more times in the other?

Thanks,
Leith Ross

The name should only appear 1 time, but they will not always be in order, and if it doesn't appear on the 2nd sheet, the macro or whatever will need to add it to the bottom of that list.

http://www.mediafire.com/?f1wwgcgcbfb

Here is a link to an example of the sheet for better clarification. There are some notes on Sheet 2.

Any takers on the assistance call? Can it even be done, or should I look for another method?

Thanks in advance!