Hey guys, I searched a lot on this topic on a bunch of forums but couldn't find what I was looking for.

So I have a contact directory with the following fields:

Name BankName Phone Email

On a separate worksheet, is it possible to have a feature where if the user selects the BankName, only the corresponding people from the bank appear in the Name field? And when the name is selected, the email and phone are automatically populated.

The second part can just be done via a vlookup I believe.

Thanks a lot for your help.

HELP from BRAZIL <<<

Dear Km1735, Good Afternoon.

I´m not sure if I understood well your doubt.

I did an example for you.
It´s attached.

Take a look at it and tell me if it worked for you.

That is amazing Mazzaropi, thanks a lot! Sorry if my question wasn't clear

I've attached the template I was trying to create. So the user would select the bank name from a drop down menu in the "template" tab (which would have a unique list of bank names from the "list" tab), and would have an option to select a person working at that bank. That person's email and phone number would just follow. Please let me know if I'm unclear.

I really appreciate the help. Very kind of you.

Thanks.

Dear Km1735,

Do you want I try to adapt the formula to your worksheet or you will do this by yourself ? I don´t know exactly what do you want now.

I will help you to solve this problem on anyway.

If you could send at least a part of your real worksheet it be better to understand your necessity.
If possible, of course.

Waiting your answer.

Try this new one

This is exactly what I was looking for! Thanks a ton. Saved my life here. Cheers!