Some minor fixes to New Mexico and Rhode Island:

=VLOOKUP(B2,{"Alabama","AL";"Alaska","AK";"Arizona","AZ";"Arkansas","AR";"California","CA";"Colorado","CO";"Connecticut","CT";"Delaware","DE";"District of Columbia","DC";"Florida","FL";"Georgia","GA";"Hawaii","HI";"Idaho","ID";"Illinois","IL";"Indiana","
IN";"Iowa","IA";"Kansas","KS";"Kentucky","KY";"Louisiana","LA";"Maine","ME";"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";"Ohio","OH";"Oklahoma","OK";"Oregon","OR";"Pennsylvania","PA";"Rhode Island","RI";"South Carolina","SC";"South Dakota","SD";"Tennessee","TN";"Texas","TX";"Utah","UT";
"Vermont","VT";"Virginia","VA";"Washington","WA";"West Virginia","WV";"Wisconsin","WI";"Wyoming","WY"},2,FALSE)

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)