Good morning,

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.

Regards.

Alberto Cortes.

Can you please clarify what "dropdown list" means. Is it data validation that's been applied to cell C7? Or is it a combobox from the ActiveX Toolbox that's embedded onto cell C7.

Also, how do the items in cells C3 and C5 get entered? Are they manually entered? Do they appear as the result of formulas that are in those cells?