Need formula help for If statements

[cclark92]

Hello, I’m trying to create a formula to that will look automatically update a cell based on another cell.
Example if Column A will have states: Virginia, North Carolina, , Maryland, California, Nevada. I need column C to be region that populates based off cell A value so Virginia=East, California= West. And so forth l

Another factor is with the data the states may change weekly so new states may come as I run the report. Any help? Thank you

 

[awoohaw]

try:

mr excel questions 25.xlsm
	A	B	C	D	E	F
1
2	Virginia		East		California	West
3	California		West		Maryland	East
4					Nevada	West
5					North Carolina	East
6					Virginia	East
cclark92

Cell Formulas
Range	Formula
C2:C3	C2	=VLOOKUP($A2,$E$2:$F$6,2,0)