oK FINALYY GOT MY DROP DOWN WORKING, BUT....

[mdhancockga]

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

[camalone319]

Can you upload what you have so far and what you're trying to get? I'm having trouble following.

[mdhancockga]

Thank you so much for looking into this - my brain is fried trying to figure this out

APS Bid Termplate WIP 5.xls

Any advice is greatly appreciated

[Danerida]

If you change the layout of your database sheet so that the whole list is in columns A:C, you can use this:

Please Login or Register  to view this content.

Dan

[camalone319]

hi, I updated your database table to one column set and used a vlookup. Please let me know if this works.APS Bid Termplate WIP 5 updated.xls

[FDibbins]

Agree with post #4 regarding a single list for all teh states, then use this...
=VLOOKUP(C3,Database!$A$2:$C$52,3,0)