I am trying to use the VLOOKUP formula to automatically select the corresponding region when a state is selected. I have a State drop down in col D. And in col E I have the formula =VLOOKUP(D2,RegionMap,2,false). In the formula editor it shows the correct result, but the formula is displaying in the cell, not the result. How do I get the result to display?

Also, how do I copy this formula down my column and have the references adapt correctly?

Any help would be greatly appreciated. Thanks!