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

Hi vjharry,

See if using an Advanced Filter isn't a better method for you. See the attached on sheet2 and use the dropdowns in row 2. This isn't perfect but might work for you.

thanks but cant this by without helper !

without helper column

Thanks Jean,

but Can we put that helper row formula in that same Data Validation<<List ... so that we doesn't need to add an extra helper column.

My Basic concern is that suppose if there are same name of two employees then i should show only those emp codes only who belongs to same name in that next data validation list.

@vjharry

I think that what solution Jean-Paul has provided you is best to care of your requirement. And I don't think that it is possible to have that kind of data validation with the help of a formula without any helper column.

If you are ok with sorting the Name column in the table, you can use a formula to create a named range and use that named range for the data validation.
So for example create a Named Range "Ecode" with the following formula and then in data validation for C3, use =Ecode in the list source.

Formula to create Ecode named range......

Please Login or Register  to view this content.

Notice in the attached sheet that I have sorted the Name column in the table.