Change text in one column if contains specific word

[wolverine21]

I need some help with a macro. Part of my macro needs to replace words in column A if a specific word is in column B (not all words will contain either word.

Below is what the report will originally look like
Column A. , Column B
Sam , Seed
Dave , Turf
Trent , Grass

The result should look like this:
Corp , Seed
Corp , Turf
Trent , Grass

Any help would really be appropriated. The attachment has a better example.

[sintek]

Please Login or Register  to view this content.

[wolverine21]

So, it was working in the original file that I sent but I'm trying it in the file I actually need to use and it doesn't seem to be working. I'll add the attachment to the original question. I can't seem to figure out how to attach it to this reply.

[wolverine21]

It's not letting me attach the file I'm trying to use.

[wolverine21]

I figured it out. I had to capitalize the words SEED and TURF in what you sent. Thank you!!