Hi,

I am very new to VBA and was wondering if there was a way to do the following.

When entering a State Name in cell Y7 it will put the Region it belongs to in cell AD7

I have a column with States. I am trying to put a VBA formula in another cell to look at that column, if the state is Washington, California, or Oregon, I want the result to be "West". If it's another range of states, it might return "Central", etc.Basically trying to tie state names for which region they are in.