Forum Discussion
AmberPollard
11 years agoQrew Assistant Captain
Since I spent a not-insignificant amount of time on this, I'd like to prevent others from having to doing the same (though it was a fun exercising in trying to remember my state abbreviations!):
If (
[Address: State/Region]="Alabama", "AL",
[Address: State/Region]="Alaska", "AK",
[Address: State/Region]="Arizona", "AZ",
[Address: State/Region]="Arkansas", "AR",
[Address: State/Region]="California", "CA",
[Address: State/Region]="Colorado", "CO",
[Address: State/Region]="Connecticut", "CT",
[Address: State/Region]="Delaware", "DE",
[Address: State/Region]="Florida", "FL",
[Address: State/Region]="Georgia", "GA",
[Address: State/Region]="Hawaii", "HI",
[Address: State/Region]="Idaho", "ID",
[Address: State/Region]="Illinois", "IL",
[Address: State/Region]="Indiana", "IN",
[Address: State/Region]="Iowa", "IA",
[Address: State/Region]="Kansas", "KS",
[Address: State/Region]="Kentucky", "KY",
[Address: State/Region]="Louisiana", "LA",
[Address: State/Region]="Maine", "ME",
[Address: State/Region]="Maryland", "MD",
[Address: State/Region]="Massachusetts", "MA",
[Address: State/Region]="Michigan", "MI",
[Address: State/Region]="Minnesota", "MN",
[Address: State/Region]="Mississippi", "MS",
[Address: State/Region]="Missouri", "MO",
[Address: State/Region]="Montana", "MT",
[Address: State/Region]="Nebraska", "NE",
[Address: State/Region]="Nevada", "NV",
[Address: State/Region]="New Hampshire", "NH",
[Address: State/Region]="New Jersey", "NJ",
[Address: State/Region]="New Mexico", "NM",
[Address: State/Region]="New York", "NY",
[Address: State/Region]="North Carolina", "NC",
[Address: State/Region]="North Dakota", "ND",
[Address: State/Region]="Ohio", "OH",
[Address: State/Region]="Oklahoma", "OK",
[Address: State/Region]="Oregon", "OR",
[Address: State/Region]="Pennsylvania", "PA",
[Address: State/Region]="Rhode Island", "RI",
[Address: State/Region]="South Carolina", "SC",
[Address: State/Region]="South Dakota", "SD",
[Address: State/Region]="Tennessee", "TN",
[Address: State/Region]="Texas", "TX",
[Address: State/Region]="Utah", "UT",
[Address: State/Region]="Vermont", "VT",
[Address: State/Region]="Virginia", "VA",
[Address: State/Region]="Washington", "WA",
[Address: State/Region]="West Virginia", "WV",
[Address: State/Region]="Wisconsin", "WI",
[Address: State/Region]="Wyoming", "WY"
)
If (
[Address: State/Region]="Alabama", "AL",
[Address: State/Region]="Alaska", "AK",
[Address: State/Region]="Arizona", "AZ",
[Address: State/Region]="Arkansas", "AR",
[Address: State/Region]="California", "CA",
[Address: State/Region]="Colorado", "CO",
[Address: State/Region]="Connecticut", "CT",
[Address: State/Region]="Delaware", "DE",
[Address: State/Region]="Florida", "FL",
[Address: State/Region]="Georgia", "GA",
[Address: State/Region]="Hawaii", "HI",
[Address: State/Region]="Idaho", "ID",
[Address: State/Region]="Illinois", "IL",
[Address: State/Region]="Indiana", "IN",
[Address: State/Region]="Iowa", "IA",
[Address: State/Region]="Kansas", "KS",
[Address: State/Region]="Kentucky", "KY",
[Address: State/Region]="Louisiana", "LA",
[Address: State/Region]="Maine", "ME",
[Address: State/Region]="Maryland", "MD",
[Address: State/Region]="Massachusetts", "MA",
[Address: State/Region]="Michigan", "MI",
[Address: State/Region]="Minnesota", "MN",
[Address: State/Region]="Mississippi", "MS",
[Address: State/Region]="Missouri", "MO",
[Address: State/Region]="Montana", "MT",
[Address: State/Region]="Nebraska", "NE",
[Address: State/Region]="Nevada", "NV",
[Address: State/Region]="New Hampshire", "NH",
[Address: State/Region]="New Jersey", "NJ",
[Address: State/Region]="New Mexico", "NM",
[Address: State/Region]="New York", "NY",
[Address: State/Region]="North Carolina", "NC",
[Address: State/Region]="North Dakota", "ND",
[Address: State/Region]="Ohio", "OH",
[Address: State/Region]="Oklahoma", "OK",
[Address: State/Region]="Oregon", "OR",
[Address: State/Region]="Pennsylvania", "PA",
[Address: State/Region]="Rhode Island", "RI",
[Address: State/Region]="South Carolina", "SC",
[Address: State/Region]="South Dakota", "SD",
[Address: State/Region]="Tennessee", "TN",
[Address: State/Region]="Texas", "TX",
[Address: State/Region]="Utah", "UT",
[Address: State/Region]="Vermont", "VT",
[Address: State/Region]="Virginia", "VA",
[Address: State/Region]="Washington", "WA",
[Address: State/Region]="West Virginia", "WV",
[Address: State/Region]="Wisconsin", "WI",
[Address: State/Region]="Wyoming", "WY"
)
RyanParr
8 years agoQrew Assistant Captain
I wish my name was Ringo! Your suggestion worked like charm - Thanks!