Switch values between columns based on drop-down selection

[satheo]

Hello, I have a calculation sheet that I want to work different based on 2 scenarios. As I have it set up, I'd like to be able to use a drop down or button to swap the values within two columns back and forth as needed by the user. Is there a simple way to do this with perhaps a macro? Thanks!

 

[satheo]

update - nevermind I was able to do it using the =SWITCH() function!