I have two combox's drop down, how would i populate data on the sheets?

[dbravo]

I have two combox's drop down, i was wondering how can i populate data on the sheets without too many ifs in my code? I have countries and industries and i want to populate sales based on country and industry but i do not want to write a long code saying if countries = 1 and industries = 1 then this, if countries = 1 and industries = 2 then this, etc... (numbers as in cell link). I am sure there is a more efficient way to do this, i just cant think of any. I am also planning on populating the data based on a cell change through vba...not sure if that is the most efficient way as well?

[simarui]

depending on your dataset you can probably use sumproduct to do this pretty neatly. can you upload a sample?

it will look something like this:

Please Login or Register  to view this content.

where dataset is a worksheet with information aligned in columns, countries, industries and sales figure are the column reference (i.e. A:A, B:B) corresponding to that information and dropdown# is a cell reference where the dropdowns are located (i.e. A1, A2)