data validation not coming

Hi ,

can we select employee code by formula putting in Data Validation in attached file.
For Ex: in attached file if I select name 'Peter James' then by Data validation it should show only two Employee codes as there are two 'Peter James' in list.
so that if i select either of employee code of Peter then Date of birth will show accordingly


thanks in advance