Spreadsheet: 826547d1682077305-how-to-pull-a-list-of-cities-based-on-a-selection-of-state-from-a-vlookup-bid-tracer-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | AL | AK | AZ | AR | CA | CO | CT | DE | FL | GA | HI | ID | IL | IN | IA | KS | KY | LA | ME | MD | MA | MI | MN | MS | MO | MT | NE | NV | NH | NJ | NM | NY | NC | ND | OH | OK | OR | PA | RI | SC | SD | TN | TX | UT | VT | VA | WA | WV | WI | WY
 | Sales Contact: |  |  | Job Type: |  |  | Project Status: |  |  | State Abr. |  | Alabama | Alaska | Arizona | Arkansas | California | Colorado | Connecticut | Delaware | Florida | Georgia | Hawaii | Idaho | Illinois | Indiana | Iowa | Kansas | Kentucky | Louisiana | Maine | Maryland | Massachusetts | Michigan | Minnesota | Mississippi | Missouri | Montana | Nebraka | Nevada | New Hampshire | New Jersey | New Mexico | New York | North Carolina | North Dakota | Ohio | Oklahoma | Oregon | Pennsylvania | Rhode Island | South Carolina | South Dakota | Tennessee | Texas | Utah | Vermont | Virginia | Washington | West Virginia | Wisconson | Wyoming
 | [NAME] |  |  | Free |  |  | Started |  |  | AL |  | Abbeville | Adak | [NAME] | Adona | [NAME] | Acres Green | Ansonia | Arden village | Alachua | Abbeville | Ahuimanu | Aberdeen | Abingdon | Advance | Ackley | Abbyville | Adairville | Abbeville | [NAME] | Aberdeen | [NAME] | Addison village | [NAME] | Abbeville | Adrian | [NAME] | Abie village | Battle Mountain | Antrim | Absecon | [NAME] | Accord | Aberdeen | Abercrombie | Aberdeen village | Achille | Adair Village | Aaronsburg | Ashaway | Abbeville | Aberdeen | Adams | Abbott | Alpine | Albany village | Abingdon | Aberdeen | Addison ([NAME]) | [NAME] | Afton |  |  |  | ABC Food Eaters
 | [NAME] |  |  | Expensive |  |  | Put Off |  |  | AK |  | Adamsville | Akhiok | Ak-Chin Village | [NAME] | Adelanto | Aguilar | [NAME] borough | Ardencroft village | Alford | Acworth | Aiea | Acequia | Addieville village | Akron | Ackworth | Abilene | Albany | [NAME] | Auburn | Aberdeen Proving Ground | Acushnet Center | Adrian | Adams | Aberdeen | Advance | Agency | Adams village | [NAME] | Berlin | [NAME] | [NAME] | Adams village | Ahoskie | Adams | Ada village | [NAME] | Adams | Abbottstown borough | [NAME] | Aiken | Agar | Adamsville | Abernathy | Alta | Alburg village | [NAME] | Aberdeen Gardens | [NAME] | Adams | Airport Road |  |  |  | Basket Case Food Distributors
 | [NAME] |  |  | Cheap |  |  | Egnore |  |  | AZ |  | Addison | Akiachak | Amado | Alicia | Agoura Hills | Air Force Academy | Bethel | Ardentown village | [NAME] | Adairsville | Ainaloa | Albion | Addison village | Alamo | Adair | Admire | [NAME] | Addis | Augusta | Accident | Adams | Ahmeek village | Adrian | Ackerman | Affton | Alberton | Ainsworth | [NAME] | Bristol | Allendale borough | Alamo | [NAME] | Alamance village | Alamo | Adamsville village | Adair | Adrian | Adamsburg borough | Bradford | Allendale | Akaska | Alamo | Abilene | Altamont | Arlington | [NAME] | Acme | [NAME] | Adell village | Albany |  |  |  | Tik Took Clockworks
 | [NAME] |  |  | Make Payments |  |  | Not My Job |  |  | AR |  | Akron | Akiak | Apache Junction | Allport | Alameda | Akron | Bethlehem Village | Bear | Altha | Adel | Anahola | American Falls | Adeline village | Albany | Adel | Agenda | [NAME] | Albany village | Bangor | Accokeek | Agawam | Akron village | Afton | Algoma | Agency village | Alder | Albion | Boulder City | Charlestown | Allenhurst borough | Alamogordo | Addison village | Albemarle | [NAME] | Addyston village | Addington | Albany | Adamstown borough | Bristol | [NAME] | Albee | Alcoa | Abram-Perezville | Alton | [NAME] | Alberta | Ahtanum | Alum Creek | Albany village | [NAME] |  |  |  | Coffee Cup Beverage Co.
 | Me Two |  |  | Forget It |  |  | Done |  |  | CA |  | Alabaster | Akutan | Arizona City | [NAME] | Alamo | [NAME] | Blue Hills | Bellefonte | Altoona | Adrian | Barbers Point Housing | [NAME] | Albany village | Albion | Afton | Agra | Allensville | [NAME] | Bar Harbor | Adelphi | Amesbury | [NAME] village | Aitkin | Alligator | Airport Drive village | Amsterdam-Churchill | Alda village | [NAME] | Claremont | Allentown borough | Albuquerque | Afton village | Alliance | [NAME] | Adelphi village | Afton | Aloha | Adamsville | [NAME] | [NAME] | Alcester | [NAME] | Ackerly | [NAME] | Barton village | [NAME] | Airway Heights | Amherstdale-Robinette | Algoma | Alcova |  |  |  | [NAME]
 |  |  |  | Don't Touch |  |  | Not Toucking It |  |  | CO |  | Albertville | Alakanuk | Arizona Village | Almyra | Albany | [NAME] | Branford Center | Bethany Beach | Alva | [NAME] | Captain [NAME] | Arbon Valley | Albers village | [NAME] | Agency | [NAME] | Anchorage | Ama | Bath | Algonquin | Amherst Center | Albion | Akeley | Amory | Alba | Anaconda-Deer Lodge County | Alexandria village | Caliente | Concord | Allenwood | Alcalde | Airmont village | Altamahaw-Ossipee | Almont | Adena village | Agra | Altamont | Addison borough | [NAME] | Antreville | [NAME] | Algood | Addison | American Fork | [NAME] village | Altavista | Albion | [NAME] | Allouez village | Alpine
 |  |  |  |  |  |  |  |  |  | CT |  | Alexander City | Alatna | [NAME] | Alpena | Alhambra | Allenspark | Bridgeport | Bethel | Andover | Alamo | [NAME] | Arco | Albion | Alfordsville | Ainsworth | Alden | Annville | Amelia | Belfast | Andrews AFB | Andover | Algonac | Albany | Anguilla | Albany | Antelope | [NAME] | [NAME] | Contoocook | [NAME] | Algodones | Akron village | [NAME] | Alsen | Akron | Akins | Amity | Akron borough | Cumberland Hill | Arcadia Lakes | [NAME] | Allardt | Adrian | [NAME] | Bennington | Amherst | [NAME] | Anmoore | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  | DE |  | [NAME] | Alcan Border | Avondale | Altheimer | Aliso [NAME] | [NAME] | Bristol | Blades | [NAME] | Alapaha | Eleele | Arimo | Aledo | Alton | Akron | [NAME] | Arlington | Amite City | Berwick | [NAME] | Arlington | [NAME] | Alberta | Arcola | Aldrich village | Arlee | Alliance | Carlin | Conway | Alpha borough | [NAME] village | Albany | [NAME] | Ambrose | Albany village | Albion | Antelope | Alba borough | East Providence | Arial | Alpena | Altamont | [NAME] | Annabella | Bradford village | Annandale | Alger | Ansted | [NAME] village | [NAME]
 |  |  |  |  |  |  |  |  |  | FL |  | Aliceville | [NAME] | Avra Valley | Altus | Almanor | [NAME] | [NAME] | Bowers | [NAME] | Albany | Ewa Beach | Ashton | Alexis village | [NAME] | [NAME] | [NAME] | Ashland | Anacoco village | Biddeford | Arbutus | Athol | [NAME] | [NAME] | Artesia | [NAME] | Ashland | [NAME] | Carson City | [NAME] | Alpine borough | [NAME] | Albertson | Ansonville | Amenia | Alexandria village | [NAME] | Arlington | Albion borough | Greenville | Atlantic Beach | Altamont | Ardmore | [NAME] | Antimony | [NAME] | Appalachia | [NAME] | Athens | Almena village | Alta
 |  |  |  |  |  |  |  |  |  | GA
 |  |  |  |  |  |  |  |  |  | HI
 |  |  |  |  |  |  |  |  |  | ID
 |  |  |  |  |  |  |  |  |  | IL
 |  |  |  |  |  |  |  |  |  | IN
 |  |  |  |  |  |  |  |  |  | IA
 |  |  |  |  |  |  |  |  |  | KS
 |  |  |  |  |  |  |  |  |  | KY
 |  |  |  |  |  |  |  |  |  | LA
 |  |  |  |  |  |  |  |  |  | ME
 |  |  |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  |  |  | MA
 |  |  |  |  |  |  |  |  |  | MI
 |  |  |  |  |  |  |  |  |  | MN
 |  |  |  |  |  |  |  |  |  | MS
 |  |  |  |  |  |  |  |  |  | MO
 |  |  |  |  |  |  |  |  |  | MT
 |  |  |  |  |  |  |  |  |  | NE
 |  |  |  |  |  |  |  |  |  | NV
 |  |  |  |  |  |  |  |  |  | NH
 |  |  |  |  |  |  |  |  |  | NJ
 |  |  |  |  |  |  |  |  |  | NM
 |  |  |  |  |  |  |  |  |  | NY
 |  |  |  |  |  |  |  |  |  | NC
 |  |  |  |  |  |  |  |  |  | ND
 |  |  |  |  |  |  |  |  |  | OH
 |  |  |  |  |  |  |  |  |  | OK
 |  |  |  |  |  |  |  |  |  | OR
 |  |  |  |  |  |  |  |  |  | PA
 |  |  |  |  |  |  |  |  |  | RI
 |  |  |  |  |  |  |  |  |  | SC
 |  |  |  |  |  |  |  |  |  | SD
 |  |  |  |  |  |  |  |  |  | TN
 |  |  |  |  |  |  |  |  |  | TX
 |  |  |  |  |  |  |  |  |  | UT
 |  |  |  |  |  |  |  |  |  | VT
 |  |  |  |  |  |  |  |  |  | VA
 |  |  |  |  |  |  |  |  |  | WA
 |  |  |  |  |  |  |  |  |  | WV
 |  |  |  |  |  |  |  |  |  | WI
 |  |  |  |  |  |  |  |  |  | WY