Specified formula cannot be entered bc it uses more than 64 levels of nesting.
I am trying to setup an IF statement so Excel can auto fill state abbreviations that match with the Area Code. I am having some success, until I reach a certian point. I have tried variations of the "&" code. But this only works to a certian point. The code I have that does work (up to 67) is as follows :
=IF(C3=Legend!$C$3,"NJ",&IF(C3=Legend!$C$4,"DC", &IF(C3=Legend!$C$5,"CT",&IF(C3=Legend!$C$6,"AL ",&IF(C3=Legend!$C$7,"WA",&IF(C3=Legend!$C$8," ME",&IF(C3=Legend!$C$9,"ID",&IF(C3=Legend!$C$1 0,"CA",&IF(C3=Legend!$C$11,"TX",&IF(C3=Legend! $C$12,"NY",&IF(C3=Legend!$C$13,"CA",&IF(C3=Leg end!$C$14,"TX",&IF(C3=Legend!$C$15,"PA",&IF(C3 =Legend!$C$16,"OH",&IF(C3=Legend!$C$17,"IL",&I F(C3=Legend!$C$18,"MN",&IF(C3=Legend!$C$19,"IN", &IF(C3=Legend!$C$20,"IL",&IF(C3=Legend!$C$21," LA",&IF(C3=Legend!$C$22,"MS",&IF(C3=Legend!$C$ 23,"GA",&IF(C3=Legend!$C$24,"MI",&IF(C3=Legend !$C$25,"OH",&IF(C3=Legend!$C$26,"FL",&IF(C3=Le gend!$C$27,"MD",&IF(C3=Legend!$C$28,"MI",&IF(C 3=Legend!$C$29,"AL",&IF(C3=Legend!$C$30,"NC",& IF(C3=Legend!$C$31,"WA",&IF(C3=Legend!$C$32,"TX" ,&IF(C3=Legend!$C$33,"AL",&IF(C3=Legend!$C$34, "IN",&IF(C3=Legend!$C$35,"WI",&IF(C3=Legend!$C $36,"PA",&IF(C3=Legend!$C$37,"MI",&IF(C3=Legen d!$C$37,"MI",&IF(C3=Legend!$C$38,"KY",&IF(C3=L egend!$C$39,"VA",&IF(C3=Legend!$C$39,"TX", &IF(C3=Legend!$H$3,"MD", &IF(C3=Legend!$H$4,"DE", &IF(C3=Legend!$H$5,"CO", &IF(C3=Legend!$H$6,"WV", &IF(C3=Legend!$H$7,"FL", &IF(C3=Legend!$H$8,"WY", &IF(C3=Legend!$H$9,"NE",& IF(C3=Legend!$H$10,"IL", &IF(C3=Legend!$H$11,"CA", &IF(C3=Legend!$H$12,"IL", &IF(C3=Legend!$H$13,"MI", &IF(C3=Legend!$H$14,"MO", &IF(C3=Legend!$H$15,"NY", &IF(C3=Legend!$H$16,"KS", &IF(C3=Legend!$H$17,"IN", &IF(C3=Legend!$H$18,"LA", &IF(C3=Legend!$H$19,"IA", &IF(C3=Legend!$H$20,"MN", &IF(C3=Legend!$H$21,"FL", &IF(C3=Legend!$H$22,"CA", &IF(C3=Legend!$H$23,"TX", &IF(C3=Legend!$H$24,"OH", &IF(C3=Legend!$H$25,"IL", &IF(C3=Legend!$H$26,"AL", &IF(C3=Legend!$H$27,"NC", &IF(C3=Legend!$H$28,"LA", &IF(C3=Legend!$H$29,"MA", &IF(C3=Legend!$H$30,"NY", &IF(C3=Legend!$H$31,"MA", &IF(C3=Legend!$H$32,"FL", &IF(C3=Legend!$H$33,"WA", &IF(C3=Legend!$H$34,"TX", &IF(C3=Legend!$H$35,"UT", &IF(C3=Legend!$H$36,"FL","N/A")))))))))))))))))))))))))))))))))))))))))))))))) )))))))))))))))))))))))
I have a legend of all area code setup on the second sheet. I need to be alble to do this with ALL area codes. Any help would be appreciated! Thanks!
|