trying to get a merge and locate to work

[crlaurence]

By entering a code in column "C", it would merge/concatenate and match column "K" info, then replace the matching <<color>> name wherever it is in column e and or f and put that compelted text, column E to A, and column F to B, if no match, blank or state No Match

An example can be located here

http://www.crlaurence.com/adv/example.xls

Thank you for any assistance