Excel 2010 drop down list and combination

Travail.xlsxTravail.xlsxHi,

First I just would like to thank you for spending times thinking about my problem.

I am kind a new with excel even though I have a long experience with computers...

I am trying to create an excel sheet who permit to calculate duty cost for different countries quickly.

The first sheet will be a page where the user will enter the value of the good, select by using a drop down list the country where
the good is heading and finally a second drop down list mentionning if the goods have been produced from inside a community who has trade agreement that reduce the duty or outside the community.(duty will be different if the origin of the good is in or out)

in separate sheets the answers of the duty is mentioned for 8 countries. each sheet one country. answers if the good come from the community or outside for each country.

The problem is mainly have the answer displayed after using the second drop list.

I simply dunno

For dependent/dynamic lists in Excel, take a look here (not sure if posting links to other sites is OK?) http://www.contextures.com/xlDataVal02.html It's one of those things that I know how to do but struggle to explain, the link above covers everything in an easy to understand way. That allows you to base the second list on the result of the first (though having re-read your question I think that this might not be what you want to do).

As a starting point, I would suggest having one list instead of multiple tabs for the tax, then we could use a vlookup() to determine what the tax should be depending on what is picked in the dropdowns.

Does that make sense?