DropDown List content depending on condition
I have been struggling with a way to how generate specific text on a cell with dropdown list with the condition on two other cells.
Basically, if Cell C3=Object1 & Cell C5=Quantity1, I would like the dropdown list on Cell C7 to include Table1, Table2, Table3
Although, if if Cell C3=Object2 & Cell C5=Quantity1, I would like the dropdown list on Cell C7 to include Table4, Table5, Table6 and so on.
Does anyone know a tactic or a macro that can help me to do this?
Thank you very much for the help.