simple update drop down list with certain cells

[rehanemis]

I have excel sheet which contains the data as (dummy data).

Code	School	Employee
123	AAB	xyz
123	AAB	MNO
123	AAB	ANO
323	CCB	Jam
323	CCB	Yoi

<tbody>
</tbody>

On the second sheet I have same columns. by using vlookup I got the results of School. So i want to get the drop list in the third column which only contains the Employee name belongs to typed code in first column or belongs to particular shcool.

any suggestion?

 

[AFPathfinder]

I'm not entirely sure what you're asking for, but I think the validation list range value can accommodate IF statements to change the source of the list.