Simple If/Then Macro

[rhybeka]

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.

[:) Sixthsense :)]

Please attach a sample workbook with expected output for better understanding

[rhybeka]

sample.xlsx

Sure thing! So my location column would be the first column, then in the column next to it, I'd need it to look at the location and assign a region.

[:) Sixthsense :)]

Thanks for the file please explain to which data we have to compare the City and get the region from where?

[rhybeka]

I just had an epiphany - a vlookup! duh! I have the regions and cities on a separate worksheet from the one I am attempting to add the Region column to. I should just be able to write a formula leveraging that information, right?

Nevermind! The Vlookup worked for what I needed. Thanks for trying to help!