How can I set up a macro code to do the following:

If a specific value is found in Column A (say: SBY), then column C should
be set to equal whatever value is found in Column B (this value could be
several different things).

Thank you!