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?