I have the following in my spreadsheet:
Col A Col B Col C Col D
Address Client TextC1 061
Address Client TextC2 051
Address Client TextC3 041
Address Client TextC4 041
Address Client TextC5 061
Address Client TextC6 051

I need to add to column c textn Dallas every time 061 shows up in col d, St
Louis every time 051 shows up in col d and Nashville every time 041 show up
in col d.

Any one have any suggestions?