Spreadsheet: 852732d1702665188-complicated-lookup-question-example
Sheet: Sheet1

TABLE 1 - COUSUBS
USPS | GEOID | ANSICODE | NAME | FUNCSTAT | [NAME] | AWATER | ALAND_SQMI | AWATER_SQMI | INTPTLAT | INTPLONG | . | . | GNIS | GEOID | AALL | Type
MN | 2711100100 | 663375 | Aastad township | A | 87836989 | 3902696 | 33.914 | 1.507 | 46.167918 | -96.07259
AL | 106790009 | 165797 | Abbeville CCD | S | 447548523 | 604327 | 172.799 | 0.233 | 31.596562 | -85.304308
GA | 1331590006 | 1936064 | Abbeville CCD | S | 301956943 | 5527193 | 116.586 | 2.134 | 31.953188 | -83.316444
SC | 4500190013 | 1938181 | Abbeville CCD | S | 485652283 | 1154776 | 187.511 | 0.446 | 34.163884 | -82.377442
ME | 2302100100 | 582314 | Abbot town | A | 89431266 | 3028017 | 34.53 | 1.169 | 45.192847 | -69.494193
WI | 5501900100 | 1582650 | Abbotsford city | F | 3764326 | 0 | 1.453 | 0 | 44.946346 | -90.327308
WI | 5507300100 | 1582650 | Abbotsford city | F | 3925241 | 0 | 1.516 | 0 | 44.940757 | -90.307747
PA | 4210500108 | 1216967 | Abbott township | A | 181240658 | 0 | 69.977 | 0 | 41.61192 | -77.713989
NC | 3705790008 | 1026615 | Abbotts Creek township | N | 78480681 | 0 | 30.302 | 0 | 35.990393 | -80.110886
NC | 3706790012 | 1026672 | Abbotts Creek township | N | 68366114 | 83708 | 26.396 | 0.032 | 36.051007 | -80.08313
NC | 3701790004 | 1026421 | Abbotts township | N | 72835548 | 16975 | 28.122 | 0.007 | 34.511257 | -78.721746
GA | 1328590012 | 1936065 | Abbottsford CCD | S | 154337719 | 32221870 | 59.59 | 12.441 | 33.09782 | -85.149321
PA | 4200100116 | 1214750 | Abbottstown borough | F | 1414125 | 19834 | 0.546 | 0.008 | 39.881766 | -76.992777
ND | 3807700100 | 1035900 | Abercrombie city | F | 854101 | 0 | 0.33 | 0 | 46.447035 | -96.729649
TABLE 2 - PLACES
USPS | GEOID | ANSICODE | NAME | LSAD | FUNCSTAT | [NAME] | AWATER | ALAND_SQMI | AWATER_SQMI | INTPTLAT | INTPTLONG | . | GNIS | GEOID | Type
PA | 4200100 | 2389113 | Aaronsburg CDP | 57 | S | 2293210 | 0 | 0.885 | 0 | 40.904233 | -77.451316
PA | 4200104 | 2584431 | Aaronsburg CDP | 57 | S | 1439694 | 0 | 0.556 | 0 | 40.010823 | -80.000926
AL | 100100 | 2582661 | Abanda CDP | 57 | S | 7764034 | 34284 | 2.998 | 0.013 | 33.091627 | -85.527029
AL | 100124 | 2403054 | Abbeville city | 25 | A | 40255361 | 107642 | 15.543 | 0.042 | 31.564706 | -85.259121
GA | 1300184 | 2403056 | Abbeville city | 25 | A | 7916461 | 96559 | 3.057 | 0.037 | 31.992576 | -83.306452
LA | 2200100 | 2403057 | Abbeville city | 25 | A | 15660962 | 83689 | 6.047 | 0.032 | 29.975395 | -92.127157
SC | 4500100 | 2403055 | Abbeville city | 25 | A | 16097781 | 31436 | 6.215 | 0.012 | 34.178544 | -82.377687
MS | 2800100 | 2405117 | Abbeville town | 43 | A | 8960349 | 0 | 3.46 | 0 | 34.503392 | -89.502517
WI | 5500100 | 1582650 | Abbotsford city | 25 | A | 7689567 | 0 | 2.969 | 0 | 44.943493 | -90.317322
TX | 4800100 | 2409653 | Abbott city | 25 | A | 1532749 | 3191 | 0.592 | 0.001 | 31.885139 | -97.074106
PA | 4200116 | 1214750 | Abbottstown borough | 21 | A | 1414125 | 19834 | 0.546 | 0.008 | 39.881766 | -76.992777
VA | 5100110 | 2807445 | Abbs Valley CDP | 57 | S | 5881450 | 14187 | 2.271 | 0.005 | 37.235392 | -81.460147
KS | 2000100 | 2393875 | Abbyville city | 25 | A | 693335 | 0 | 0.268 | 0 | 37.970576 | -98.202961
ND | 3800100 | 1035900 | Abercrombie city | 25 | A | 854101 | 0 | 0.33 | 0 | 46.447035 | -96.729649