If X in C4, copy to E4, Dependent Validation

[sammipd]

I've set up Dependent Data Validation so when a specific Session is selected only specific options are available in the next two columns. However, the third column the user is to input a number. The only restriction is for the Session called Previous Group. Those two dependent validation columns read "Reported Above" but when i set up a dependent validation for the third column it makes the whole column dropdown only regardless of Session. How can I tell it to auto-enter Reported Above if Previous Group is selected, or if the next two columns show as Reported Above?Using Excel365

Session	Topic1	Topic2	#Attending		Session		Group		PreviousGroup		One_tne
Group	Class B	Class A			Group		Class A		Reported Above		Class A
PreviousGroup	Reported Above	Reported Above			PreviousGroup		Class B				Class B
PreviousGroup	Reported Above	Reported Above			One_tne		Class C				Class C
One_tne	Class A	Class B
Group	Class A	Class C
PreviousGroup	Reported Above	Reported Above

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>