Look in Excel Help at the Vlookup function

--
Regards,
Tom Ogilvy

"Tim" wrote in message
...
Hi,

Is it possible to take the addresses from sheet 2 and add them to sheet 1.

Column A has the same names and format on both sheets, they are just in
different order. The data I work with is almost 50,000 records long or I
would just copy and past, or sort, filter or something. But its not that
easy!

I'm trying to find a vba way to match up the names so that I can get the
addresses to add to the correct name.

Any ideas?

Thx in advance.