I need a Excel Formula and Macro Expert

Job ID: 35466778

Budget: $10 – $30 USD

Need to change the value of a column if a specific value is existing on the other column. Its urgent. So if you have no time to do it right now please don't bid. Thanks in advance.