Hi there! I need to create a formula that checks if cell b2 matches the range of values in column "c" including if value has more than 1 word and special characters then copy value in column "d" in the same row where the match was found and add it to the beginning of value in cell b2 and add "|" after the value in column "d" and before value from column "c" (don't copy values from column "c"). I'm attaching an excel with the desired results. Thanks!
Bookmarks