data validation

I used data validation function & v-lookup function for other columns, however in my list I have for example people with the same surname in one column but different names in the other column – but if I choose a duplicate surname it wont choose any other name – how can I solve this problem so that if I choose a surname that is duplicated it will give me other names.