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?

Are these control dropdowns (combobox) or are they lists generated through the data validation menu?

Combobox.