Spreadsheet: 772321d1647199153-vlookup-on-a-different-worksheet-and-a-nested-if-function-cities-using-ssti
Sheet: Tier 2 Cities

 |  |  |  |  |  |  |  |  |  | 3 square mile miimum except glendale
Current SSTI customer |  |  |  |  |  | [NAME] | Total City Square Miles | Annual Contract Size |  |  | Potential expansion
 | 26 | Las Vegas, Nevada |  | Las Vegas | NV | 24
 |  | Detroit |  | Detroit | MI | 6.5
 |  | Memphis |  | Memphis | TN | 3
 |  | Louisville, Kentucky[19] |  | Louisville | KY | 6
 |  | Baltimore |  | Baltimore | MD | 10 |  | 759000
 |  | Milwaukee, Wisconsin |  | Milwaukee | WI | 11
 |  | Albuquerque, New Mexico |  | Albuquerque | NM | 6
 |  | Tucson, Arizona |  | Tucson | AZ
 |  | Fresno, California |  | Fresno | CA |  |  |  |  |  |  | 17.5
 |  | Sacramento, California |  | Sacramento | CA |  |  |  | 65000
 |  | Kansas City, Missouri |  | Kansas City | MO | 3.55
 |  | Mesa, Arizona |  | Mesa | AZ
 |  | Atlanta, Georgia |  | Atlanta | GA
 |  | Omaha, Nebraska |  | Omaha | NE | 4
 |  | Colorado Springs, Colorado |  | Colorado Springs | CO
 |  | Raleigh, North Carolina |  | Raleigh | NC
 |  | Long Beach, California |  | Long Beach | CA
 |  | Virginia Beach, Virginia[16] |  | Virginia Beach | VA | 3 |  | 240000
 |  | Miami, Florida |  | Miami | FL | 23
 |  | Oakland, California |  | Oakland | CA | 15.38 | 25% of the city | 592010
 |  | Minneapolis, Minnesota |  | Minneapolis | MN | 6
 |  | Tulsa, Oklahoma |  | Tulsa | OK
 |  | Bakersfield, California |  | Bakersfield | CA | 6.19
 |  | Wichita, Kansas |  | Wichita | KS
 |  | Arlington, Texas |  | Arlington | TX
 |  | [NAME], Colorado |  | [NAME] | CO
 |  | Tampa, Florida |  | Tampa | FL | 4
 |  | New Orleans, Louisiana[20] |  | New Orleans | LA
 |  | Cleveland, Ohio |  | Cleveland | OH | 3
 |  | Honolulu CDP, Hawaii[2] |  | Honolulu CPD | HI
 |  | Anaheim, California |  | Anaheim | CA
 |  | Lexington, Kentucky[21] |  | Lexington | KY
 |  | [NAME], California |  | [NAME] | CA
 |  | Corpus Christi, Texas |  | Corpus Christi | TX
 |  | Henderson, Nevada |  | Henderson | NV
 |  | Riverside, California |  | Riverside | CA
 |  | Newark, New Jersey |  | Newark | NJ | 7
 |  | [NAME], Minnesota |  | [NAME] | MN
 |  | Santa Ana, California |  | Santa Ana | CA
 |  | Cincinnati, Ohio |  | Cincinnati | OH | 13
 |  | [NAME], California |  | [NAME] | CA
 |  |  |  | Orlando | FL
 |  | Pittsburgh, Pennsylvania |  | Pittsburgh | PA | 18 |  | 110000
 |  | St. Louis, Missouri[16] |  | St. Louis | MO | 14
 |  | Greensboro, North Carolina |  | Greensboro | NC
 |  | Jersey City, New Jersey |  | Jersey City | NJ
 |  | Anchorage, Alaska[22] |  | Anchorage | AK
 |  |  |  | Lincoln | NE
 |  | Plano, Texas |  | Plano | TX
 |  | [NAME], North Carolina |  | [NAME] | NC
 |  | Buffalo, New York |  | Buffalo | NY
 |  | [NAME], Arizona |  | [NAME] | AZ
 |  | [NAME], California |  | [NAME] | CA
 |  | Toledo, Ohio |  | Toledo | OH | 12
 |  | [NAME], Wisconsin |  | [NAME] | WI
 |  | [NAME], Arizona[24] |  | [NAME] | AZ
 |  | Reno, Nevada |  | Reno | NV
 |  | [NAME], Indiana |  | [NAME] | IN
 |  | North Las Vegas, Nevada |  | North Las Vegas | NV
 |  | Saint Petersburg, Florida |  | Saint Petersburg | FL
 |  | Lubbock, Texas |  | Lubbock | TX
 |  | Irving, Texas |  | Irving | TX
 |  | Laredo, Texas |  | Laredo | TX
 |  | Winston–Salem, North Carolina |  | Winston-Salem | NC | 3
 |  | Chesapeake, Virginia[16] |  | Chesapeake | VA
 |  | Glendale, Arizona |  | Glendale | AZ | 2
 |  |  |  | Scottsdale | AZ
 |  |  |  | Garland | TX
 |  | Norfolk, Virginia[16] |  | Norfolk | VA
 |  |  |  | Boise | ID
 |  | Fremont, California |  | Fremont | CA
 |  |  |  | Spokane | WA
 |  |  |  | Santa Clara | CA
 |  | Baton Rouge, Louisiana[23] |  | Baton Rouge | LA | 7
 |  |  |  | Richmond | VA | 3
 |  |  |  | Total
 |  |  |  | [NAME] | Cities |  | Total Opportunity
 |  |  | [NAME]NewOpportunity | 8.5 |  | 50000
 |  |  | [NAME] Opportunity