Spreadsheet: 34377d1231577606-macro-to-search-text-and-return-values-book1-3
Sheet: Sheet1

State | Code | Result |  | your original values…some discreprencies because of inconsistencies (pairs highlighted) |  |  |  |  |  |  |  |  | Code | Result | State | Abbr
Texas | ASB | TX APPSVC |  |  | TX APPSVC |  |  |  |  |  |  |  | asb | APPSVC | ALABAMA | AL
Texas | ASNB |  |  |  | 0 |  |  |  |  |  |  |  | nsb | NETSVC | ALASKA | AK
Florida | NSB | FL NETSVC |  |  | FL NETSVC |  |  |  |  |  |  |  | tba | APPTVL | AMERICAN SAMOA | AS
Maine | NSNB |  |  |  | 0 |  |  |  |  |  |  |  | tbn | NETTVL | ARIZONA | AZ
Maine | TBN | ME NETTVL |  |  | ME NETTVL |  |  |  |  |  |  |  |  |  | ARKANSAS | AR
Oregon | TNB |  |  |  | 0 |  |  |  |  |  |  |  |  |  | CALIFORNIA | CA
California | ASB | CA APPSVC |  |  | CA APPSVC |  |  |  |  |  |  |  |  |  | COLORADO | CO
California | ASNB |  |  |  | 0 |  |  |  |  |  |  |  |  |  | CONNECTICUT | CT
Ohio | TBA | OH APPTVL |  |  | OH APPSVC |  |  |  |  |  |  |  |  |  | DELAWARE | DE
Oregon | NSB | OR NETSVC |  |  | OR APPSVC |  |  |  |  |  |  |  |  |  | DISTRICT OF COLUMBIA | DC
New York | ASNB |  |  |  | 0 |  |  |  |  |  |  |  |  |  | FEDERATED STATES OF MICRONESIA | FM
Maine | ASB | ME APPSVC |  |  | ME APPSVC |  |  |  |  |  |  |  |  |  | FLORIDA | FL
Nevada | ASB | NV APPSVC |  |  | NV APPSVC |  |  |  |  |  |  |  |  |  | GEORGIA | GA
Arizona | TBA | AZ APPTVL |  |  | AZ APPTVL |  |  |  |  |  |  |  |  |  | GUAM | GU
Arizona | ASB | AZ APPSVC |  |  | AZ APPSVC |  |  |  |  |  |  |  |  |  | HAWAII | HI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IDAHO | ID
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ILLINOIS | IL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INDIANA | IN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IOWA | IA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KANSAS | KS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KENTUCKY | KY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOUISIANA | LA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAINE | ME
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARSHALL ISLANDS | MH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARYLAND | MD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MASSACHUSETTS | MA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MICHIGAN | MI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MINNESOTA | MN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MISSISSIPPI | MS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MISSOURI | MO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTANA | MT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEBRASKA | NE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEVADA | NV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEW HAMPSHIRE | NH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEW JERSEY | NJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEW MEXICO | NM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NEW YORK | NY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORTH CAROLINA | NC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORTH DAKOTA | ND
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORTHERN MARIANA ISLANDS | MP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OHIO | OH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OKLAHOMA | OK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OREGON | OR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PALAU | PW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PENNSYLVANIA | PA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PUERTO RICO | PR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RHODE ISLAND | RI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOUTH CAROLINA | SC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOUTH DAKOTA | SD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TENNESSEE | TN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TEXAS | TX
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UTAH | UT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | VT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VIRGIN ISLANDS | VI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VIRGINIA | VA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WASHINGTON | WA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST VIRGINIA | WV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WISCONSIN | WI
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WYOMING | WY