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
What would need to be added to this formula to allow any value not stated above to be passed through? i.e. if the state field value equals "Whatever", that it passes through "Whatever".