Currently I have =IF(C3="AR",DATABASE!$C$4,IF(C3="AK",DATABASE!$C$5,0...))etc .....well I populated this list referencing the states and their database line - until I received specified formula cannot be entered - nesting limit....ETC ...each entry represents a state on a drop down menu - each state represents a numeric value on a different tab (or the "database") I need to enter 50 states plus one additional line item and have them reference each state and its specified number - but it cut me off at 10 entries - im using excel 2013 - I am sure that the way im doing it is way off - I just don't know the code or how to make it - if they select a state it will pull up the number -- everything was working fine til I received the error message...
please help and thank you in advance