Hello, I have a column of customers (A) and a column of Part #s (B).
I also have a short column of part #s (C). If a part in (B) is found in (C),
I want it to change to a totally different customer, say it is in (D). If it
doesn't match I want it to stay the same.
Thanks for looking.
Mike