On Sep 29, 8:16*am, scr wrote:
I have an original list of addresses. *A "reroute" list is provided. *If
columns A, B, & C on the original list *match columns A, B, & C on the
"reroute" list the addresses in columns *D, E, F, G & H must be changed to
the new addresses listed on the "reroute" list columns D, E, F, G & H. *

If, however, there is not match then the address in the original list needs
to stay the same.

Any suggestions?

One way...
In I2 on the sheet with the original list of addresses...
=IF(SUMPRODUCT(--(Sheet2!$A$2:$A$11=$A2),--(Sheet2!$B$2:$B$11=$B2),--
(Sheet2!$C$2:$C$11=$C2))=0,D2,SUMPRODUCT(--(Sheet2!$A$2:$A$11=$A2),--
(Sheet2!$B$2:$B$11=$B2),--(Sheet2!$C$2:$C$11=$C2),Sheet2!D$2:D$11))

Fill across to M2 then down to the bottom of list of original
addresses.
Then hide the columns D to H of original addresses.

As is formula works for maximum of 10 reroutes on a sheet named
Sheet2.

Edit the formula to suit the number of reroutes and the reroute sheet
name.

Ken Johnson