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