Hi, I'm trying to extrapolate/compare missing cities from column C compared to column B. Column B is the full city list... Is there an easy way to do that? Or can someone do it for me? I would greatly appreciate it!
www.dropbox.com
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Trying to extrapolate/compare missing cities
- Thread starter erikcg123
- Start date
Hi, I'm trying to extrapolate/compare missing cities from column C compared to column B. Column B is the full city list... Is there an easy way to do that? Or can someone do it for me? I would greatly appreciate it!
Dropbox - File Deleted - Simplify your life
Upvote
0
| missing cities.xlsx | |||||
|---|---|---|---|---|---|
| B | C | D | |||
| 1 | Full List | MyList | Is Mylist in Full List | ||
| 12 | Lubbock | Selma | #N/A | ||
| 14 | Garland | Anderson Mill | #N/A | ||
| 20 | Pasadena | Cedar Creek | #N/A | ||
| 27 | Carrollton | Lago Vista | #N/A | ||
| 36 | The Woodlands | Spicewood | #N/A | ||
| 43 | Edinburg | Bayou Vista | #N/A | ||
| 45 | Bryan | Beasley | #N/A | ||
| 50 | Flower Mound | Brookside | #N/A | ||
| 53 | Temple | China | #N/A | ||
| 55 | Georgetown | Clear Lake Shores | #N/A | ||
| 60 | Rowlett | Creekside Park | #N/A | ||
| 61 | Harlingen | Crosby | #N/A | ||
| 62 | San Marcos | Crystal Beach | #N/A | ||
| 63 | Pflugerville | Cypress | #N/A | ||
| 64 | Spring | Damon | #N/A | ||
| 65 | Leander | Danbury | #N/A | ||
| 77 | Keller | Guy | #N/A | ||
| 78 | Kyle | Hamshire | #N/A | ||
| 80 | Haltom City | High Island | #N/A | ||
| 81 | The Colony | Highlands | #N/A | ||
| 83 | Sherman | Hockley | #N/A | ||
| 85 | Schertz | Huffman | #N/A | ||
| 89 | Friendswood | Jamaica Beach | #N/A | ||
| 91 | Duncanville | Jones Creek | #N/A | ||
| 93 | Mission Bend | Kemah | #N/A | ||
| 94 | Rosenberg | Kingwood | #N/A | ||
| 106 | Southlake | Montgomery | #N/A | ||
| 108 | Midlothian | Needville | #N/A | ||
| 109 | Cleburne | New Caney | #N/A | ||
| 113 | Greenville | Pinehurst | #N/A | ||
| 115 | Converse | Port Bolivar | #N/A | ||
| 117 | Hutto | Porter | #N/A | ||
| 118 | Colleyville | Richards | #N/A | ||
| 122 | Cloverleaf | Rosharon | #N/A | ||
| 129 | Denison | Splendora | #N/A | ||
| 132 | San Benito | Stagecoach | #N/A | ||
| 137 | Kerrville | Tiki Island | #N/A | ||
| 141 | Belton | Wallis | #N/A | ||
| 146 | Murphy | West Texas: | #N/A | ||
| 156 | Brushy Creek | Bishop | #N/A | ||
| 164 | Alton | Ganado | #N/A | ||
| 172 | Pampa | Los Fresnos | #N/A | ||
| 178 | Highland Village | Monte Alto | #N/A | ||
| 179 | Mercedes | Odem | #N/A | ||
| 186 | Live Oak | Progreso Lakes | #N/A | ||
| 187 | Sulphur Springs | Rancho Viejo | #N/A | ||
| 194 | Addison | Santa Rosa | #N/A | ||
| 196 | Kilgore | Sullivan City | #N/A | ||
| 198 | Hewitt | Tivoli | #N/A | ||
| 211 | Levelland | Bartonville | #N/A | ||
| 214 | Rendon | Blue Mound | #N/A | ||
| 215 | Glenn Heights | Blue Ridge | #N/A | ||
| 224 | Richmond | Cross Roads | #N/A | ||
| 225 | Borger | Cross Timber | #N/A | ||
| 249 | La Homa | Grandview | #N/A | ||
| 252 | Rockport | Haslet | #N/A | ||
| 259 | Jacinto City | Italy | #N/A | ||
| 260 | Granbury | Josephine | #N/A | ||
| 267 | Commerce | Krugerville | #N/A | ||
| 271 | Hondo | Lakeside | #N/A | ||
| 272 | Liberty | Lakewood Village | #N/A | ||
| 283 | Whitehouse | Mesquite | #N/A | ||
| 288 | Dayton | Oak Leaf | #N/A | ||
| 291 | Dalhart | Palmer | #N/A | ||
| 299 | Lake Dallas | Providence Village | #N/A | ||
| 301 | Bridge City | Rhome | #N/A | ||
| 314 | Gonzales | Shady Shores | #N/A | ||
| 332 | Sunnyvale | ||||
| 333 | Silsbee | ||||
| 334 | Pecan Plantation | ||||
| 335 | Scenic Oaks | ||||
| 336 | Camp Swift | ||||
| 337 | Bridgeport | ||||
| 338 | Keene | ||||
| 339 | Carthage | ||||
| 340 | Sealy | ||||
| 341 | Crockett | ||||
| 342 | Iowa Park | ||||
| 343 | Burnet | ||||
| 344 | White Oak | ||||
| 345 | Kermit | ||||
| 346 | Port Isabel | ||||
| 347 | Everman | ||||
| 348 | Lindale | ||||
| 349 | Mont Belvieu | ||||
| 350 | Travis Ranch | ||||
| 351 | Homestead Meadows South | ||||
| 352 | Gun Barrel City | ||||
| 353 | Childress | ||||
| 354 | Penitas | ||||
| 355 | Alpine | ||||
| 356 | Gladewater | ||||
| 357 | Slaton | ||||
| 358 | Progreso | ||||
| 359 | Littlefield | ||||
| 360 | Windcrest | ||||
| 361 | Luling | ||||
| 362 | Hutchins | ||||
| 363 | Yoakum | ||||
| 364 | Nolanville | ||||
| 365 | Edna | ||||
| 366 | Salida del Sol Estates | ||||
| 367 | Cameron Park | ||||
| 368 | Savannah | ||||
| 369 | Belterra | ||||
| 370 | Lackland AFB | ||||
| 371 | Wake Village | ||||
| 372 | Marlin | ||||
| 373 | Brookshire | ||||
| 374 | Rusk | ||||
| 375 | Sansom Park | ||||
| 376 | Willow Park | ||||
| 377 | Zapata | ||||
| 378 | Muleshoe | ||||
| 379 | Rockdale | ||||
| 380 | Heartland | ||||
| 381 | Cameron | ||||
| 382 | Atlanta | ||||
| 383 | San Leon | ||||
| 384 | Breckenridge | ||||
| 385 | Carrizo Springs | ||||
| 386 | Terrell Hills | ||||
| 387 | Sinton | ||||
| 388 | Iowa Colony | ||||
| 389 | Brady | ||||
| 390 | Bulverde | ||||
| 391 | Briar | ||||
| 392 | McGregor | ||||
| 393 | Anthony and Diboll | ||||
| 394 | Center | ||||
| 395 | Livingston | ||||
| 396 | Granite Shoals | ||||
| 397 | Gilmer | ||||
| 398 | Wolfforth | ||||
| 399 | Homestead Meadows North | ||||
| 400 | Lakehills | ||||
| 401 | Giddings | ||||
| 402 | Krum | ||||
| 403 | Oak Point | ||||
| 404 | Bowie | ||||
| 405 | Doolittle | ||||
| 406 | Hudson | ||||
| 407 | Pinehurst CDP | ||||
| 408 | Primera | ||||
| 409 | Post | ||||
| 410 | Canutillo | ||||
| 411 | Dripping Springs | ||||
| 412 | Lake Worth | ||||
| 413 | Parker | ||||
| 414 | Meadows Place | ||||
| 415 | Doffing | ||||
| 416 | Denver City | ||||
| 417 | Hunters Creek Village | ||||
| 418 | Devine | ||||
| 419 | Aledo | ||||
| 420 | Mineola | ||||
| 421 | Mathis | ||||
| 422 | Madisonville | ||||
| 423 | Hebbronville | ||||
| 424 | Hickory Creek | ||||
| 425 | Wilmer | ||||
| 426 | Rio Bravo | ||||
| 427 | Tulia | ||||
| 428 | La Grange | ||||
| 429 | Pittsburg | ||||
| 430 | Liberty Hill | ||||
| 431 | New Boston | ||||
| 432 | Sandy Oaks | ||||
| 433 | Medina | ||||
| 434 | Palacios | ||||
| 435 | Morgan's Point Resort | ||||
| 436 | Smithville | ||||
| 437 | Fabens | ||||
| 438 | Castle Hills | ||||
| 439 | Pilot Point | ||||
| 440 | Dilley | ||||
| 441 | Falfurrias | ||||
| 442 | Hearne | ||||
| 443 | Jacksboro | ||||
| 444 | La Joya | ||||
| 445 | Caldwell | ||||
| 446 | Aubrey | ||||
| 447 | Jourdanton | ||||
| 448 | Coleman | ||||
| 449 | Hallsville | ||||
| 450 | Spring Valley Village | ||||
| 451 | Alvarado | ||||
| 452 | Argyle | ||||
| 453 | Pecan Acres | ||||
| 454 | Bellville | ||||
| 455 | Groesbeck | ||||
| 456 | Port Aransas | ||||
| 457 | ****rell Hill | ||||
| 458 | Comanche and Sullivan City | ||||
| 459 | Cotulla | ||||
| 460 | Horseshoe Bay | ||||
| 461 | Van Alstyne | ||||
| 462 | La Paloma | ||||
| 463 | Justin | ||||
| 464 | Dimmitt | ||||
| 465 | San Diego | ||||
| 466 | Garden Ridge | ||||
| 467 | Laureles | ||||
| 468 | Whitesboro | ||||
| 469 | Venus | ||||
| 470 | Ovilla | ||||
| 471 | Nassau Bay | ||||
| 472 | North Alamo | ||||
| 473 | Midway North | ||||
| 474 | Richwood | ||||
| 475 | Bunker Hill Village | ||||
| 476 | San Carlos | ||||
| 477 | Potosi and Presidio | ||||
| 478 | Sonterra | ||||
| 479 | Canton | ||||
| 480 | Colorado City | ||||
| 481 | Shavano Park | ||||
| 482 | Sparks | ||||
| 483 | West Columbia | ||||
| 484 | Eastland | ||||
| 485 | Grape Creek | ||||
| 486 | Crandall | ||||
| 487 | Weston Lakes | ||||
| 488 | Friona | ||||
| 489 | Shady Hollow | ||||
| 490 | Clyde | ||||
| 491 | Val Verde Park | ||||
| 492 | Nash | ||||
| 493 | Cisco | ||||
| 494 | Mabank | ||||
| 495 | Eagle Lake | ||||
| 496 | Taylor Lake Village | ||||
| 497 | Sweeny | ||||
| 498 | Ballinger | ||||
| 499 | Columbus | ||||
| 500 | Central Gardens | ||||
| 501 | Wyldwood | ||||
| 502 | Wills Point | ||||
| 503 | Crane | ||||
| 504 | Chula Vista CDP | ||||
| 505 | Farmersville | ||||
| 506 | Dublin | ||||
| 507 | McLendon-Chisholm | ||||
| 508 | Teague | ||||
| 509 | Scissors | ||||
| 510 | Lavon | ||||
| 511 | Llano | ||||
| 512 | Rosita | ||||
| 513 | Poteet | ||||
| 514 | Elm Creek | ||||
| 515 | Bullard | ||||
| 516 | Piney Point Village | ||||
| 517 | Clifton and Cedar Creek | ||||
| 518 | Abernathy | ||||
| 519 | Karnes City | ||||
| 520 | Kenedy | ||||
| 521 | Barrett | ||||
| 522 | Westway | ||||
| 523 | Sonora | ||||
| 524 | Redwood | ||||
| 525 | Hollywood Park | ||||
| 526 | The Homesteads | ||||
| 527 | Winnsboro | ||||
| 528 | Reno city | ||||
| 529 | Edcouch | ||||
| 530 | West Lake Hills | ||||
| 531 | West Orange | ||||
| 532 | Lake Cherokee | ||||
| 533 | Waller | ||||
| 534 | Cactus | ||||
| 535 | Cross Mountain | ||||
| 536 | Big Lake | ||||
| 537 | Howe | ||||
| 538 | Haskell | ||||
| 539 | Northlake | ||||
| 540 | Annetta | ||||
| 541 | Laguna Vista | ||||
| 542 | Huntington | ||||
| 543 | Wimberley | ||||
| 544 | El Cenizo city | ||||
| 545 | Oak Ridge North | ||||
| 546 | Hideaway | ||||
| 547 | Grand Saline | ||||
| 548 | San Saba | ||||
| 549 | Balcones Heights | ||||
| 550 | Spearman | ||||
| 551 | Clarksville | ||||
| 552 | Needville and Early | ||||
| 553 | Reno | ||||
| 554 | Double Oak | ||||
| 555 | Olney | ||||
| 556 | Castroville | ||||
| 557 | Bishop and Chandler | ||||
| 558 | Brazoria | ||||
| 559 | Henrietta | ||||
| 560 | Springtown | ||||
| 561 | Overton | ||||
| 562 | Troy | ||||
| 563 | Comfort | ||||
| 564 | Combes | ||||
| 565 | Paloma Creek | ||||
| 566 | Hamilton | ||||
| 567 | Edgecliff Village | ||||
| 568 | Rancho Viejo town | ||||
| 569 | Nocona | ||||
| 570 | DeCordova | ||||
| 571 | Stanton | ||||
| 572 | Ranger | ||||
| 573 | Citrus City | ||||
| 574 | Shenandoah | ||||
| 575 | Seymour | ||||
| 576 | Taft | ||||
| 577 | Schulenburg | ||||
| 578 | McQueeney | ||||
| 579 | Onalaska and Stamford | ||||
| 580 | Shady Shores and Fairfield | ||||
| 581 | West | ||||
| 582 | Seagraves | ||||
| 583 | Mauriceville | ||||
| 584 | Woodville | ||||
| 585 | Salado | ||||
| 586 | Ferris | ||||
| 587 | Weimar | ||||
| 588 | Palmview South | ||||
| 589 | El Lago | ||||
| 590 | Magnolia | ||||
| 591 | South Padre Island | ||||
| 592 | La Villa | ||||
| 593 | Canadian | ||||
| 594 | Mount Vernon | ||||
| 595 | Trinity | ||||
| 596 | Circle D-KC Estates | ||||
| 597 | Refugio | ||||
| 598 | Santa Rosa town | ||||
| 599 | Electra | ||||
| 600 | Ozona and Hooks | ||||
| 601 | Beach City | ||||
| 602 | Palmhurst | ||||
| 603 | Panhandle | ||||
| 604 | Westworth Village | ||||
| 605 | Floydada | ||||
| 606 | Van | ||||
| 607 | Oak Trail Shores | ||||
| 608 | Junction | ||||
| 609 | Daingerfield and Perezville | ||||
| 610 | Winnie | ||||
| 611 | Blanco | ||||
| 612 | Inez | ||||
| 613 | Shadybrook | ||||
| 614 | Glen Rose | ||||
| 615 | Hedwig Village | ||||
| 616 | Freer | ||||
| 617 | Rio Hondo | ||||
| 618 | Panorama Village | ||||
| 619 | Escobares | ||||
| 620 | Tool | ||||
| 621 | Fritch | ||||
| 622 | Tahoka | ||||
| 623 | Merkel | ||||
| 624 | Hallettsville and Hudson Oaks | ||||
| 625 | Bolivar Peninsula | ||||
| 626 | Indian Hills | ||||
| 627 | Cienegas Terrace | ||||
| 628 | Talty | ||||
| 629 | Shallowater | ||||
| 630 | George West | ||||
| 631 | Premont | ||||
| 632 | Winters | ||||
| 633 | Malakoff | ||||
| 634 | Leonard | ||||
| 635 | Agua Dulce CDP | ||||
| 636 | Arcola | ||||
| 637 | Palmer town | ||||
| 638 | Lyford | ||||
| 639 | Combine | ||||
| 640 | South Alamo | ||||
| 641 | Jefferson | ||||
| 642 | Kirbyville | ||||
| 643 | Holly Lake Ranch | ||||
| 644 | Garfield | ||||
| 645 | La Blanca | ||||
| 646 | De Leon | ||||
| 647 | Shepherd | ||||
| 648 | Nixon | ||||
| 649 | Pantego | ||||
| 650 | St. Hedwig | ||||
| 651 | Sour Lake | ||||
| 652 | Hudson Bend | ||||
| 653 | Lytle | ||||
| 654 | Hackberry | ||||
| 655 | Lake Kiowa and Pottsboro | ||||
| 656 | The Hills | ||||
| 657 | Barton Creek | ||||
| 658 | Ponder | ||||
| 659 | Quanah | ||||
| 660 | Bushland | ||||
| 661 | East Bernard | ||||
Sheet1 | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D12,D14,D20,D27,D36,D43,D45,D50,D53,D55,D60:D65,D77:D78,D80:D81,D83,D85,D89,D91,D93:D94,D106,D108:D109,D113,D115,D117:D118,D122,D129,D132,D137,D141,D146,D156,D164,D172,D178:D179,D186:D187,D194,D196,D198,D211,D214:D215,D224:D225,D249,D252,D259:D260,D267 | D12 | =VLOOKUP(C12,$B$2:$B$661,1,FALSE) |
Upvote
0
| missing cities.xlsx | |||||
|---|---|---|---|---|---|
| B | C | D | |||
| 1 | Full List | MyList | Is Mylist in Full List | ||
| 2 | Houston | Alamo Heights | Alamo Heights | ||
| 3 | San Antonio | Boerne | Boerne | ||
| 4 | Dallas | Converse | Converse | ||
| 5 | Austin | Helotes | Helotes | ||
| 6 | Fort Worth | Live Oak | Live Oak | ||
| 7 | El Paso | New Braunfels | New Braunfels | ||
| 8 | Arlington | Pleasanton | Pleasanton | ||
| 9 | Corpus Christi | San Antonio | San Antonio | ||
| 10 | Plano | Schertz | Schertz | ||
| 11 | Laredo | Seguin | Seguin | ||
| 12 | Lubbock | Selma | #N/A | ||
| 13 | Irving | Universal City | Universal City | ||
| 14 | Garland | Anderson Mill | #N/A | ||
Sheet1 | |||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| D2:D14 | D2 | =VLOOKUP(C2,$B$2:$B$661,1,FALSE) |
Upvote
0
Similar threads
- Solved
- Question
