Here you go the validation lists you had to set up according to this link:

http://www.contextures.com/xlDataVal02.html

and if you scroll down to the "Using Dynamic Lists". It worked.

Here is the file with it working.

Sonepar Technology Team PO's & Invoices 2012.xlsx