Spreadsheet: 61201d1262019210-need-assistance-with-returning-multiple-values-statescities
Sheet: data

helper to generate unique values for look up | state | towns/cities
Alabama-1 | Alabama | aaaa
Alabama-2 | Alabama | ggg
Alabama-3 | Alabama | mmm
Alaska-1 | Alaska | bbbb
Alaska-2 | Alaska | hhh
Alaska-3 | Alaska | nnn
Alaska-4 | Alaska | ccccc
Alaska-5 | Alaska | iii
American Samoa-1 | American Samoa | ooo
Arizona-1 | Arizona | aaaa
Arizona-2 | Arizona | ggg
Arizona-3 | Arizona | lll
Arizona-4 | Arizona | uuuu
Arizona-5 | Arizona | vvvv
Arizona-6 | Arizona | tttt
Arkansas-1 | Arkansas | bbbb
Arkansas-2 | Arkansas | hhh
Arkansas-3 | Arkansas | mmm
California-1 | California | ccccc
California-2 | California | iii
California-3 | California | nnn
Colorado-1 | Colorado | aaaa
Colorado-2 | Colorado | ggg
Colorado-3 | Colorado | ooo
Connecticut-1 | Connecticut | bbbb
Connecticut-2 | Connecticut | hhh
Connecticut-3 | Connecticut | lll
Delaware-1 | Delaware | ccccc
Delaware-2 | Delaware | iii
Delaware-3 | Delaware | mmm
District of Columbia-1 | District of Columbia | aaaa
District of Columbia-2 | District of Columbia | ggg
District of Columbia-3 | District of Columbia | qqq
Florida-1 | Florida | bbbb
Florida-2 | Florida | hhh
Florida-3 | Florida | rrr
Georgia-1 | Georgia | ccccc
Georgia-2 | Georgia | iii
Georgia-3 | Georgia | sss
Guam-1 | Guam | aaaa
Guam-2 | Guam | ggg
Guam-3 | Guam | qqq
Hawaii-1 | Hawaii | bbbb
Hawaii-2 | Hawaii | hhh
Hawaii-3 | Hawaii | rrr
Idaho-1 | Idaho | ccccc
Idaho-2 | Idaho | iii
Idaho-3 | Idaho | sss
Illinois-1 | Illinois | aaaa
Illinois-2 | Illinois | ggg
Illinois-3 | Illinois | qqq
Indiana-1 | Indiana | bbbb
Indiana-2 | Indiana | hhh
Indiana-3 | Indiana | rrr
Iowa-1 | Iowa | ccccc
Iowa-2 | Iowa | iii
Iowa-3 | Iowa | sss
Kansas-1 | Kansas | aaaa
Kansas-2 | Kansas | ggg
Kansas-3 | Kansas | qqq
Kentucky-1 | Kentucky | bbbb
Kentucky-2 | Kentucky | lll
[NAME] | Kentucky | rrr
Louisiana-1 | Louisiana | ccccc
Louisiana-2 | Louisiana | mmm
Louisiana-3 | Louisiana | sss
Maine-1 | Maine | aaaa
Maine-2 | Maine | nnn
Maine-3 | Maine | qqq
Maryland-1 | Maryland | bbbb
Maryland-2 | Maryland | ooo
Maryland-3 | Maryland | rrr
Massachusetts-1 | Massachusetts | ccccc
Massachusetts-2 | Massachusetts | lll
Massachusetts-3 | Massachusetts | sss
Michigan-1 | Michigan | aaaa
Michigan-2 | Michigan | mmm
Michigan-3 | Michigan | qqq
Minnesota-1 | Minnesota | ddd
Minnesota-2 | Minnesota | nnn
Minnesota-3 | Minnesota | rrr
Mississippi-1 | Mississippi | eeee
Mississippi-2 | Mississippi | ooo
Mississippi-3 | Mississippi | sss
Missouri-1 | Missouri | ddd
Missouri-2 | Missouri | lll
Missouri-3 | Missouri | qqq
[NAME] | Montana | eeee
Montana-2 | Montana | mmm
Montana-3 | Montana | rrr
Nebraska-1 | Nebraska | ddd
Nebraska-2 | Nebraska | nnn
Nebraska-3 | Nebraska | sss
Nevada-1 | Nevada | eeee
Nevada-2 | Nevada | ooo
Nevada-3 | Nevada | qqq
New Hampshire-1 | New Hampshire | ddd
New Hampshire-2 | New Hampshire | lll
New Hampshire-3 | New Hampshire | rrr
New Jersey-1 | New Jersey | eeee
New Jersey-2 | New Jersey | mmm
New Jersey-3 | New Jersey | sss
New Mexico-1 | New Mexico | ddd
New Mexico-2 | New Mexico | nnn
New Mexico-3 | New Mexico | qqq
New York-1 | New York | eeee
New York-2 | New York | ooo
New York-3 | New York | rrr
North Carolina-1 | North Carolina | ddd
North Carolina-2 | North Carolina | lll
North Carolina-3 | North Carolina | sss
North Dakota-1 | North Dakota | eeee
North Dakota-2 | North Dakota | mmm
North Dakota-3 | North Dakota | qqq
Northern Marianas Islands-1 | Northern Marianas Islands | ddd
Northern Marianas Islands-2 | Northern Marianas Islands | nnn
Northern Marianas Islands-3 | Northern Marianas Islands | rrr
[NAME] | Ohio | eeee
Ohio-2 | Ohio | ooo
Ohio-3 | Ohio | sss
Oklahoma-1 | Oklahoma | ddd
Oklahoma-2 | Oklahoma | lll
Oklahoma-3 | Oklahoma | qqq
Oregon-1 | Oregon | eeee
Oregon-2 | Oregon | mmm
Oregon-3 | Oregon | rrr
Pennsylvania-1 | Pennsylvania | ddd
Pennsylvania-2 | Pennsylvania | nnn
Pennsylvania-3 | Pennsylvania | sss
Puerto Rico-1 | Puerto Rico | eeee
Puerto Rico-2 | Puerto Rico | ooo
Puerto Rico-3 | Puerto Rico | qqq
[NAME] | Rhode Island | ddd
[NAME] | Rhode Island | lll
[NAME] | Rhode Island | tttt
South Carolina-1 | South Carolina | eeee
South Carolina-2 | South Carolina | mmm
South Carolina-3 | South Carolina | uuuu
South Dakota-1 | South Dakota | ddd
South Dakota-2 | South Dakota | nnn
South Dakota-3 | South Dakota | vvvv
Tennessee-1 | Tennessee | eeee
Tennessee-2 | Tennessee | ooo
Tennessee-3 | Tennessee | tttt
Texas-1 | Texas | ggg
Texas-2 | Texas | lll
Texas-3 | Texas | uuuu
Utah-1 | Utah | hhh
Utah-2 | Utah | mmm
Utah-3 | Utah | vvvv
Vermont-1 | Vermont | iii
Vermont-2 | Vermont | nnn
Vermont-3 | Vermont | tttt
Virgin Islands-1 | Virgin Islands | hhh
Virgin Islands-2 | Virgin Islands | lll
Virgin Islands-3 | Virgin Islands | vvvv
Virginia-1 | Virginia | ggg
Virginia-2 | Virginia | ooo
Virginia-3 | Virginia | uuuu
Washington-1 | Washington | iii
Washington-2 | Washington | mmm
Washington-3 | Washington | tttt
West Virginia-1 | West Virginia | ggg
West Virginia-2 | West Virginia | nnn
West Virginia-3 | West Virginia | uuuu
Wisconsin-1 | Wisconsin | hhh
Wisconsin-2 | Wisconsin | ooo
Wisconsin-3 | Wisconsin | vvvv
Wyoming-1 | Wyoming | iii
Wyoming-2 | Wyoming | lll
Wyoming-3 | Wyoming | tttt