Flexible and conditional drop-down list


New Member
Jun 7, 2019
Hi everyone,

I am working for a project for my company and would need some help on an issue I have.

Ultimately, I want to create a model that is as flexible as a PivotTable without using a PivotTable. The reason for this that I won't be able to change any fields.

I am working with conditional drop-down lists in order to retrieve data that is linked to a SUMIF formula. Even though it is a good start it does not offer me the full flexibility of a PivotTable since the lists are conditional on each other. Let's say that if I have 10 different drop-down lists in Column A to J and the different drop-down lists are dependent on each other. Is there a way I can structure it so that at any point I can retrieve the data based on just column A and D and at the same time just a single column?

If for example, Column A = Country), B = Month), C = Product), D = Area

Column A includes: Germany, Spain and Australia
Column C includes: Coca Cola, Fanta and Water

I want to have the possibility to see the sales for Coca Cola in Germany, but at the same time, I want to have the possibility to see the total sales for Coca Cola based on all the different countries in the drop-down list. Is there a way in which this can be achieved?

I know it works in a PivotTable but I want to know if it's possible achieve the same flexibility by building a model and not using IF function because the database is to large for building such a formula.

Thankful for any suggestions!


Well-known Member
Mar 11, 2015
Last edited:


New Member
Jun 7, 2019
Hi Yongle,

Thanks for your reply, that's exactly what I did. Do you happen to know if it is possible to link formulas to the slicers?

Thank you

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...