Adding a value to a column based on values in another column fro the same worksheet

I have 2 columns called 'Visibility' and 'MTW Status' in AC and AU respectively and shown in blue.

MTW Status column has text values that are either 'Matching' 'Non-Matching' 'Matching and Updated' or 'New Row'
The Visiblity column needs to updated based on these values in the status column.

'Non-Matching' to represented by a '0' in the visibility, the other 3 text values to be represented by the number '4'

I want to be able to run a macro to make this happen.

Would appreciate any help in making this work.

I've enclosed an example file to highlight the areas that i'm talking about

Regards
John

Jaslake, that is fantastic, copy, paste and worked flawlessly. And many thanks for the fast response. Gladly added a star.

regards
John