ExcelBanter - adding addresses to a file from another file

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - adding addresses to a file from another file (https://www.excelbanter.com/excel-discussion-misc-queries/166037-adding-addresses-file-another-file.html)

bookish

adding addresses to a file from another file

I have a file with names and pay rates and I need to add the addresses from
another file. The file with names has multiple listings for each person, but
the address file only has each person once. Is there a formula or a macro I
can use for this?

All times are GMT +1. The time now is 11:44 AM.