Simple If/Then Macro

Hi All!

I need to create a simple if/then VBA in Excel. I'd just use it as a formula but I have too many variables even for a nested. I need Excel to check a column of locations and if (for example) a location = Columbus, Oh, then put a value in the column to the right of it of United states. I have about 30 locations to do, hence the reason I can't seem to get just a formula to work it appears. Plus, I have to repeat this on a monthly basis. If someone would point me in the right direction I would greatly appreciate it!

Becky

Sorry all - realized I posted in the wrong forum for VBA. If this can be done via a formula I'd be ok with that as well. IF/And just hasn't worked out very well either.