Cell content dependant on contents of two Dropdowns (ComboBox)
Hi I need to compare the contents of 2 dropdowns and then populate a field with some text in Excel.
e.g. if dropdown 1 = x, dropdown 2= y cell G7 = P
if dropdown 1 = x, dropdown 2= z cell G7 = c
if dropdown 1 = y, dropdown 2= y cell G7 = q
and so on.
Any ideas?
Re: Cell content dependant on contents of two Dropdowns (Excel)
Are these control dropdowns (combobox) or are they lists generated through the data validation menu?
Re: Cell content dependant on contents of two Dropdowns (Excel)