Spreadsheet: 673061d1587140047-trouble-with-wildcards-in-vlookup-wildcard-vlookup-test
Sheet: Sheet1

Zips | Territory | [NAME]
T0A,T0B,T0C,T0E,T0G,T0H,T0J,T0K,T0L,T0M,T0P,T0V,T1A,T1B,T1C,T1G,T1H,T1J,T1K,T1M,T1P,T1R,T1S,T1V,T1W,T1X,T1Y,T1Z,T2A,T2B,T2C,T2E,T2G,[NAME],T2J,T2K,T2L,T2M,T2N,T2P,T2R,T2S,T2T,T2V,T2W,T2X,T2Y,T2Z,T3A,T3B,T3C,[NAME],T3G,T3H,[NAME],T3K,T3L,T3M,T3N,T3P,T3R,T3S,T3Z,T4A,T4B,T4C,T4E,T4G,[NAME],T4J,T4L,T4M,T4N,[NAME],T4R,T4S,T4T,T4V,T4X,T5A,T5B,T5C,T5E,T5G,T5H,T5J,T5K,T5L,T5M,T5N,T5P,T5R,T5S,T5T,T5V,T5W,T5X,T5Y,T5Z,T6A,T6B,T6C,T6E,T6G,T6H,T6J,T6K,T6L,T6M,T6P,T6R,T6S,T6T,T6V,T6W,T6X,T7A,T7E,T7N,T7P,T7S,T7V,T7X,T7Y,T7Z,T8A,T8B,T8C,T8E,T8G,T8H,T8L,T8N,T8R,T8S,T8T,T8V,T8W,T8X,T9A,T9C,[NAME],T9G,T9H,T9J,T9K,[NAME],[NAME],T9S,T9V,T9W,T9X,V0A,V0B,V0G,V0H,V1A,V1B,V1C,V1H,[NAME],V1N,V1P,V1R,V1T,V1V,[NAME],V1X,V1Y,V1Z,V2A,V4T,V4V | Alberta | [NAME] |  | 80004
80002,80003,80004,80005,80007,80020,80021,80022,80023,80025,80026,80027,80030,80031,80033,80203,80205,80206,80207,80211,80212,80214,80215,80216,80218,80220,80221,80229,80233,80234,80238,80239,80241,80249,80260,80266,80301,80302,80303,80304,80305,80309,80310,80428,80442,80446,80447,80451,80453,80455,80457,80459,80463,80466,80467,80469,80478,80479,80481,80482,80483,80487,80501,80503,80504,80510,80512,80513,80514,80515,80516,80517,80520,80521,80524,80525,80526,80528,80530,80534,80535,80536,80537,80538,80540,80542,80543,80544,80545,80546,80547,80549,80550,80551,80601,80602,80603,80610,80611,80612,80615,80620,80621,80622,80623,80624,80631,80634,80639,80640,80642,80643,80644,80645,80646,80648,80649,80650,80651,80652,80653,80654,80701,80705,80723,80729,80733,80742,80750,80754,81639,82063,87001,87004,87008,87010,87013,87015,87024,87025,87027,87041,87043,87044,87046,87047,87048,87052,87053,87056,87059,87072,87083,87102,87104,87105,87106,87107,87108,87109,87110,87111,87112,87113,87114,87116,87120,87121,87122,87123,87124,87144,87151,871MX,87501,87505,87506,87507,87508,87540 | New Mexico | [NAME]
83348,83676,97001,97002,97003,97004,97005,97006,97007,97008,97009,97010,97011,97013,97014,97015,97016,97017,97018,97019,97020,97021,97022,97023,97024,97026,97027,97028,97030,97031,97032,97034,97035,97037,97038,97040,97041,97042,97044,97045,97048,97049,97051,97053,97054,97055,97056,97057,97058,97060,97062,97063,97064,97067,97068,97070,97071,97078,97080,97086,97089,970MX,97101,97102,97103,97106,97107,97108,97109,97110,97111,97112,97113,97114,97115,97116,97117,97118,97119,97121,97122,97123,97124,97125,97127,97128,97130,97131,97132,97133,97134,97135,97136,97137,97138,97140,97141,97144,97145,97146,97147,97148,97149,971MX,97201,97202,97203,97204,97205,97206,97208,97209,97210,97211,97212,97213,97214,97215,97216,97217,97218,97219,97220,97221,97222,97223,97224,97225,97227,97229,97230,97231,97232,97233,97236,97239,97258,97266,97267,97301,97302,97303,97304,97305,97306,97310,97312,97317,97321,97322,97324,97325,97326,97327,97329,97330,97331,97333,97335,97336,97338,97341,97342,97343,97344,97345,97346,97347,97348,97350,97351,97352,97355,97357,97358,97360,97361,97362,97364,97365,97366,97367,97368,97369,97370,97371,97373,97374,97375,97376,97377,97378,97380,97381,97383,97384,97385,97386,97388,97389,97390,97391,97392,97394,97396,973MX,97401,97402,97403,97404,97405,97408,97410,97412,97413,97416,97417,97419,97424,97426,97429,97430,97431,97432,97434,97435,97436,97437,97438,97439,97441,97442,97443,97446,97447,97448,97451,97452,97453,97454,97455,97456,97457,97461,97462,97463,97467,97469,97470,97471,97473,97475,97477,97478,97479,97480,97481,97484,97486,97487,97488,97489,97490,97492,97493,97494,97495,97496,97497,97498,97499,974MX,97501,97502,97503,97504,97520,97522,97523,97524,97525,97526,97527,97530,97531,97532,97534,97535,97536,97537,97538,97539,97540,97541,97543,97544,975MX,97701,97702,97703,97707,97711,97712,97730,97734,97739,97741,97751,97752,97753,97754,97756,97759,97760,97761,977MX,98336,98348,98355,98356,98361,98377,98501,98502,98503,98505,98506,98512,98513,98516,98520,98526,98527,98530,98531,98532,98533,98535,98536,98537,98538,98539,98541,98542,98547,98550,98552,98557,98559,98562,98563,98564,98565,98566,98568,98569,98570,98571,98572,98575,98576,98577,98579,98581,98582,98585,98586,98587,98589,98590,98591,98593,98595,98596,98597,985MX,98601,98602,98603,98604,98605,98606,98607,98609,98610,98611,98612,98613,98614,98616,98617,98619,98620,98621,98624,98625,98626,98628,98629,98631,98632,98635,98638,98639,98640,98641,98642,98643,98644,98645,98647,98648,98649,98650,98651,98660,98661,98662,98663,98664,98665,98670,98671,98672,98673,98674,98675,98682,98683,98684,98685,98686,986MX,99322,99356 | Oregon | [NAME]
84006,84017,84020,84024,84033,84036,84044,84047,84055,84060,84061,84065,84070,84081,84084,84088,84092,84093,84094,84095,84096,84098,84101,84102,84103,84104,84105,84106,84107,84108,84109,84111,84112,84113,84115,84116,84117,84118,84119,84120,84121,84123,84124,84128,84129,84138,84143,84148,84150,84199,98001,98002,98003,98004,98005,98006,98007,98008,98010,98011,98012,98014,98019,98020,98021,98022,98023,98024,98026,98027,98028,98029,98030,98031,98032,98033,98034,98036,98037,98038,98039,98040,98042,98043,98045,98047,98051,98052,98053,98055,98056,98057,98058,98059,98065,98070,98072,98074,98075,98077,98087,98092,98101,98102,98103,98104,98105,98106,98107,98108,98109,98110,98112,98115,98116,98117,98118,98119,98121,98122,98125,98126,98133,98134,98136,98144,98146,98148,98154,98155,98158,98164,98166,98168,98174,98177,98178,98181,98188,98195,98198,98199,98201,98203,98204,98207,98208,98224,98236,98239,98249,98251,98253,98256,98260,98272,98275,98277,98278,98282,98288,98290,98294,98296,98303,98304,98310,98311,98312,98314,98315,98321,98323,98327,98328,98329,98330,98332,98333,98335,98337,98338,98340,98342,98345,98346,98349,98351,98354,98359,98360,98366,98367,98370,98371,98372,98373,98374,98375,98380,98383,98385,98387,98388,98390,98391,98392,98394,98396,98397,98402,98403,98404,98405,98406,98407,98408,98409,98413,98416,98418,98421,98422,98424,98433,98438,98439,98443,98444,98445,98446,98465,98466,98467,98498,98499,98524,98528,98546,98548,98555,98560,98580,98584,98588,98592 | Utah | [NAME]
80010,80011,80012,80013,80014,80015,80016,80017,80018,80019,80045,80101,80102,80103,80104,80105,80106,80107,80108,80109,80110,80111,80112,80113,80116,80117,80118,80120,80121,80122,80123,80124,80125,80126,80127,80128,80129,80130,80131,80132,80133,80134,80135,80136,80137,80138,80202,80204,80208,80209,80210,80219,80222,80223,80224,80226,80227,80228,80230,80231,80232,80235,80236,80237,80246,80247,80257,80264,80265,80290,80293,80294,80299,80401,80403,80420,80421,80422,80423,80424,80425,80426,80432,80433,80435,80436,80438,80439,80440,80443,80444,80448,80449,80452,80453,80454,80456,80457,80461,80465,80468,80470,80476,80497,80498,80808,80809,80813,80814,80816,80817,80819,80820,80827,80829,80830,80831,80832,80835,80840,80860,80863,80864,80902,80903,80904,80905,80906,80907,80908,80909,80910,80911,80913,80914,80915,80916,80917,80918,80919,80920,80921,80922,80923,80924,80925,80926,80927,80928,80929,80930,80938,80939,80941,80946,80949,80951,80977,80995,809MX,81228,81251,81426,81435,81611,81615,81620,81621,81623,81631,81632,81637,81642,81645,81649,81654,81655,81656,81657,84006,84009,84017,84018,84020,84024,84033,84036,84044,84047,84055,84060,84061,84065,84070,84081,84084,84088,84092,84093,84094,84095,84096,84098,84101,84102,84103,84104,84105,84106,84107,84108,84109,84111,84112,84113,84115,84116,84117,84118,84119,84120,84121,84122,84123,84124,84128,84129,84138,84143,84148,84150,84199 | Colorado | [NAME]
96701,96703,96704,96705,96706,96707,96708,96710,96712,96713,96714,96716,96717,96718,96719,96720,96722,96725,96727,96728,96729,96730,96731,96732,96734,96737,96738,96740,96741,96742,96743,96744,96746,96747,96748,96749,96750,96751,96752,96753,96754,96755,96756,96757,96759,96760,96761,96762,96763,96764,96765,96766,96768,96769,96770,96771,96772,96773,96774,96776,96777,96778,96779,96780,96781,96782,96783,96784,96785,96786,96789,96790,96791,96792,96793,96795,96796,96797,967MX,96813,96814,96815,96816,96817,96818,96819,96821,96822,96825,96826,96850,96853,96857,96858,96859,96860,96861,96863 | Hawaii | Gina