Cell Population based on a Table

[JimS]

How can I populate a cell based on "various values" of another cell?

Column A contains the 2-Character Abbreviations for all the State
(United States that is). I would like to populate Column B with th
“Area” that the state is in based on my predetermined mapping.

In example: MA, NJ, NY are in the East Area, VA, MD, NC, SC are in th
MidAtlantic Area, IL, ND, SD, IW are in the MidWest Area, TX, FL, L
are in the South Area, etc

Can a formula do this or does it need a Macro. I would think that
would need to build a reference table for the “States to Area
mapping/relationship

 

[Ardus Petus]

You do need a reference table with col States & col Area

Then you can search that table using VLOOKUP

HTH

 

[Dave Peterson]

I would create a new worksheet (call it sheet2).

Put the 2 character abbreviation in column A and its associated region in column
B.

Then I'd use a formula in an adjacent cell:

=if(a2="","",vlookup(a2,sheet2!a:b,2,false))