Any way to rewrite this formula? Instead of looking at State for “BC”, using {City}
SWITCH(
{State},
“CT”, “New England”,
“ME”, “New England”,
“MA”, “New England”,
“NH”, “New England”,
“RI”, “New England”,
“VT”, “New England”,
“NJ”, “Mid-Atlantic”,
“NY”, “Mid-Atlantic”,
“PA”, “Mid-Atlantic”,
“IL”, “Midwest”,
“IN”, “Midwest”,
“MI”, “Midwest”,
“OH”, “Midwest”,
“WI”, “Midwest”,
“IA”, “Midwest”,
“KS”, “Midwest”,
“MN”, “Midwest”,
“MO”, “Midwest”,
“NE”, “Midwest”,
“ND”, “Midwest”,
“SD”, “Midwest”,
“TX”, “Southwest”,
“OK”, “Southwest”,
“LA”, “Southwest”,
“AR”, “Southwest”,
“DE”, “South Atlantic”,
“FL”, “South Atlantic”,
“GA”, “South Atlantic”,
“MD”, “South Atlantic”,
“NC”, “South Atlantic”,
“SC”, “South Atlantic”,
“WV”, “South Atlantic”,
“VA”, “South Atlantic”,
“DC”, “South Atlantic”,
“KY”, “Southeast”,
“AL”, “Southeast”,
“MS”, “Southeast”,
“TN”, “Southeast”,
“CA”, “Pacific”,
“AK”, “Pacific”,
“HI”, “Pacific”,
“OR”, “Pacific”,
“WA”, “Pacific”,
“AZ”, “Mountain”,
“CO”, “Mountain”,
“NM”, “Mountain”,
“UT”, “Mountain”,
“MT”, “Mountain”,
“WY”, “Mountain”,
“NV”, “Mountain”,
“ID”, “Mountain”,
“AB”, “Prairies”,
“SK”, “Prairies”,
“MB”, “Prairies”,
“ON”, “Central Canada”,
“QC”, “Central Canada”,
“NS”, “Atlantic Canada”,
“NB”, “Atlantic Canada”,
“PEI”, “Atlantic Canada”,
“NL”, “Atlantic Canada”,
)
SWITCH(
{City},
“Vancouver”, “Lower Mainland”
)
