Help for dynamic dependent drop down box

I amtrying to build a worksheet to simplify my job, but get stuck on this place.

Bacically, I have one data base (table) with 2 colums,(A and B), A has all the names for all the conponents, and second on has serial numbers for the corresponding component.
what I want to do is, in cell no.1, say C1, i put the component name with drop down box from data validation, (this part is done), then cell no.2, D1, i want to have a drop down box show all the serial number based on the previous component i choose.

Here is an exmple of my original data table
Name SN
pencil 123
eraser 122
pencil 134
eraser 345
pen 239
pen 309
eraser 987
pencil 087


Note:
I have read some relitave solusions, for instance, creat other couples of tables only have SN for pencil, pen, eraser respectively. But this solution is not applicable for this case since I have a lots of data. it is impossible to do that individually.

Thanks in advance!