I have the following code which set sets the row range based upon Combobox1.Value
Set Rng = Sheets("Variance Database").Range("A7:A" & Sheets("Variance Database").Range("A" & Rows.Count).End(xlUp).Row).Find(Me.Combobox1.Value)

What I need is some finishing code which will populate Combobox2 based upon information from the row combobox 1 has taken it to.

Search Column Q for value:

If no value and column E = "A", "B", "C" then populate comboxbox2 with "Host"
If no value and column E = "D", "E", "F" then populate combobox2 with "Agent"
If value then do not populate combobox2

Search Column R for Value
If no value and column E = "A", "B", "C" then populate combobox2 with "Buyer"
If no value and column E = "D", "E", "F" then populate combobox2 with "Engineer"
If value then do not populate combobox2

Search Column s for Value
If no value and column E = "A", "B", "C" then populate combobox2 with "Person"
If no value and column E = "D" then populate combobox2 with "Artist"
If value then or no value and Column E = "E", "F" do not populate combobox2

Search Column T for Value
If no value and column E = "A", "B", "C" then populate combobox2 with "Example"
If no value and column E = "D", then populate combobox2 with "Worker"
If value then or no value and Column E = "E", "F" do not populate combobox2

Thanks for any help in advance.