Spreadsheet: 197334d1354298602-reducing-a-formula-book1
Sheet: Sheet1

IF(LEN(D2)=8, |  | Choose/Lookup | Number | Result | Index | Code |  | 2003 will not look near this!!
(IF((LEFT(D2,"01")="1"),"AL", |  | 1 | 11494359 | AL | 1 | AL
(IF((LEFT(D2,"01")="2"),"AK", |  | 24 | 245930925 | MN | 2 | AK
(IF((LEFT(D2,"01")="3"),"AZ", |  | 78 | 785930925 | VI | 3 | AZ
(IF((LEFT(D2,"01")="4"),"AR", |  |  |  |  | 4 | AR
(IF((LEFT(D2,"01")="5"),"CA", |  |  |  |  | 5 | CA
,IF((LEFT(D2,"01")="6"),"CO", |  |  |  |  | 6 | CO
(IF((LEFT(D2,"01")="7"),"CT", |  |  |  |  | 7 | CT
(IF((LEFT(D2,"01")="8"),"DE", |  |  |  |  | 8 | DE
(IF((LEFT(D2,"01")="9"),"DC") |  |  |  |  | 9 | DC
(IF((LEFT(D2,"02")="10"),"FL", |  |  |  |  | 10 | FL
IF((LEFT(D2,"02")="11"),"GA", |  |  |  |  | 11 | GA
IF((LEFT(D2,"02")="12"),"HI", |  |  |  |  | 12 | HI
IF((LEFT(D2,"02")="13"),"ID", |  |  |  |  | 13 | ID
IF((LEFT(D2,"02")="14"),"IL", |  |  |  |  | 14 | IL
IF((LEFT(D2,"02")="15"),"IN", |  |  |  |  | 15 | IN
IF((LEFT(D2,"02")="16"),"IA", |  |  |  |  | 16 | IA
IF((LEFT(D2,"02")="17"),"KS", |  |  |  |  | 17 | KS
IF((LEFT(D2,"02")="18"),"KY", |  |  |  |  | 18 | KY
IF((LEFT(D2,"02")="19"),"LA", |  |  |  |  | 19 | LA
IF((LEFT(D2,"02")="20"),"ME", |  |  |  |  | 20 | ME
IF((LEFT(D2,"02")="21"),"MD", |  |  |  |  | 21 | MD
IF((LEFT(D2,"02")="22"),"MA", |  |  |  |  | 22 | MA
IF((LEFT(D2,"02")="23"),"MI", |  |  |  |  | 23 | MI
IF((LEFT(D2,"02")="24"),"MN", |  |  |  |  | 24 | MN
IF((LEFT(D2,"02")="27"),"MT", |  |  |  |  | 25 | MT
IF((LEFT(D2,"02")="25"),"MS", |  |  |  |  | 26 | MS
IF((LEFT(D2,"02")="26"),"MO", |  |  |  |  | 27 | MO
IF((LEFT(D2,"02")="28"),"NE", |  |  |  |  | 28 | NE
IF((LEFT(D2,"02")="29"),"NV", |  |  |  |  | 29 | NV
IF((LEFT(D2,"02")="30"),"NH", |  |  |  |  | 30 | NH
IF((LEFT(D2,"02")="31"),"NJ", |  |  |  |  | 31 | NJ
IF((LEFT(D2,"02")="32"),"NM", |  |  |  |  | 32 | NM
IF((LEFT(D2,"02")="33"),"NY", |  |  |  |  | 33 | NY
IF((LEFT(D2,"02")="34"),"NC", |  |  |  |  | 34 | NC
IF((LEFT(D2,"02")="35"),"ND", |  |  |  |  | 35 | ND
IF((LEFT(D2,"02")="36"),"OH", |  |  |  |  | 36 | OH
IF((LEFT(D2,"02")="37"),"OK", |  |  |  |  | 37 | OK
IF((LEFT(D2,"02")="38"),"OR", |  |  |  |  | 38 | OR
[NAME]", |  |  |  |  | 39 | PA
IF((LEFT(D2,"02")="40"),"RI", |  |  |  |  | 40 | RI
IF((LEFT(D2,"02")="41"),"SC", |  |  |  |  | 41 | SC
IF((LEFT(D2,"02")="42"),"SD", |  |  |  |  | 42 | SD
IF((LEFT(D2,"02")="43"),"TN", |  |  |  |  | 43 | TN
IF((LEFT(D2,"02")="44"),"TX", |  |  |  |  | 44 | TX
IF((LEFT(D2,"02")="45"),"UT", |  |  |  |  | 45 | UT
IF((LEFT(D2,"02")="46"),"VT", |  |  |  |  | 46 | VT
IF((LEFT(D2,"02")="47"),"VA", |  |  |  |  | 47 | VA
IF((LEFT(D2,"02")="48"),"WA", |  |  |  |  | 48 | WA
IF((LEFT(D2,"02")="49"),"WV", |  |  |  |  | 49 | WV
IF((LEFT(D2,"02")="50"),"WI", |  |  |  |  | 50 | WI
IF((LEFT(D2,"02")="51"),"WY", |  |  |  |  | 51 | WY
IF((LEFT(D2,"02")="60"),"AS", |  |  |  |  | 60 | AS
IF((LEFT(D2,"02")="61"),"FM", |  |  |  |  | 61 | FM
IF((LEFT(D2,"02")="66"),"GU", |  |  |  |  | 66 | GU
IF((LEFT(D2,"02")="67"),"MH", |  |  |  |  | 67 | MH
IF((LEFT(D2,"02")="68"),"MP", |  |  |  |  | 68 | MP
IF((LEFT(D2,"02")="69"),"PW", |  |  |  |  | 69 | PW
IF((LEFT(D2,"02")="70"),"CN", |  |  |  |  | 70 | CN
IF((LEFT(D2,"02")="72"),"PR", |  |  |  |  | 72 | PR
IF((LEFT(D2,"02")="75"),"TT", |  |  |  |  | 75 | TT
IF((LEFT(D2,"02")="78"),"VI", |  |  |  |  | 78 | VI