Loop through Column and Find matching text then add text to new cell

Hi,

I want to check cells in column B for text i.e. "MISTAKE", if found I want to change the value of cell in column A in the same row to "FOUND IT"

Tried to hash together some code I found on forums but clearly not doing this right:

Please Login or Register  to view this content.

Thanks

Please Login or Register  to view this content.

Amazing thank you for the quick reply