On Sep 30, 9:13*am, scr wrote:
Hi Ken,

I tried you formula, it worked for some but not for all -- I got some #Value
errors. *Cany you explain what your formula actually does in lay mans terms? *
Maybe it will help me understand it better.

"Ken Johnson" wrote:
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

Hi scr,

I must retract my suggestion!
It only works with numbers.

Ken Johnson