Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Population based on a Table
How can I populate a cell based on "various values" of another cell? Column A contains the 2-Character Abbreviations for all the States (United States that is). I would like to populate Column B with the “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 the MidAtlantic Area, IL, ND, SD, IW are in the MidWest Area, TX, FL, LA are in the South Area, etc Can a formula do this or does it need a Macro. I would think that I would need to build a reference table for the “States to Area” mapping/relationship. -- JimS ------------------------------------------------------------------------ JimS's Profile: http://www.excelforum.com/member.php...fo&userid=9876 View this thread: http://www.excelforum.com/showthread...hreadid=529644 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Population based on a Table
You do need a reference table with col States & col Area
Then you can search that table using VLOOKUP HTH -- AP "JimS" a écrit dans le message de ... How can I populate a cell based on "various values" of another cell? Column A contains the 2-Character Abbreviations for all the States (United States that is). I would like to populate Column B with the "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 the MidAtlantic Area, IL, ND, SD, IW are in the MidWest Area, TX, FL, LA are in the South Area, etc Can a formula do this or does it need a Macro. I would think that I would need to build a reference table for the "States to Area" mapping/relationship. -- JimS ------------------------------------------------------------------------ JimS's Profile: http://www.excelforum.com/member.php...fo&userid=9876 View this thread: http://www.excelforum.com/showthread...hreadid=529644 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Population based on a Table
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)) JimS wrote: How can I populate a cell based on "various values" of another cell? Column A contains the 2-Character Abbreviations for all the States (United States that is). I would like to populate Column B with the “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 the MidAtlantic Area, IL, ND, SD, IW are in the MidWest Area, TX, FL, LA are in the South Area, etc Can a formula do this or does it need a Macro. I would think that I would need to build a reference table for the “States to Area” mapping/relationship. -- JimS ------------------------------------------------------------------------ JimS's Profile: http://www.excelforum.com/member.php...fo&userid=9876 View this thread: http://www.excelforum.com/showthread...hreadid=529644 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions | |||
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions |