simple update drop down list with certain cells

[rehanemis]

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

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Code[/TD]
[TD]School[/TD]
[TD]Employee [/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]AAB[/TD]
[TD]xyz[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]AAB[/TD]
[TD]MNO[/TD]
[/TR]
[TR]
[TD]123[/TD]
[TD]AAB[/TD]
[TD]ANO[/TD]
[/TR]
[TR]
[TD]323[/TD]
[TD]CCB[/TD]
[TD]Jam[/TD]
[/TR]
[TR]
[TD]323[/TD]
[TD]CCB[/TD]
[TD]Yoi[/TD]
[/TR]
</tbody>[/TABLE]

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.