Dependent validation for a contact directory

[km1735]

Hey guys, I searched a lot on this topic on a bunch of forums bu
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 th
user selects the BankName, only the corresponding people from the ban
appear in the Name field? And when the name is selected, the email an
phone are automatically populated.

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

Thanks a lot for your help

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Mazzaropi]

Hey guys, I searched a lot on this topic on a bunch of forums bu
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 th
user selects the BankName, only the corresponding people from the ban
appear in the Name field? And when the name is selected, the email an
phone are automatically populated.
The second part can just be done via a vlookup I believe.
Thanks a lot for your help.

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

+-------------------------------------------------------------------
|Filename: 25-04-2012_ExcelBanter_Contacts_List_HELP_From_BRAZIL.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=342
+-------------------------------------------------------------------

 

[km1735]

Try this new one

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

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Mazzaropi]

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

Dear *KM1735*, Good Morning.

I feel glad that my help worked for you.
Have a nice day

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[km1735]

Dear *KM1735*, Good Morning.

I feel glad that my help worked for you.
Have a nice day.

Thanks Mazzaropi,

Sorry this is pretty dumb of me, but I can't figure out how to use th
template for more rows. For example, if I use the same data validatio
in cells A3(Banks) and B3(Contacts) of the template, the list doesn'
change (contacts for banks in cells A2 appear there too).

I was trying to fix it, but couldn't get it working. Thanks

+-------------------------------------------------------------------
+-------------------------------------------------------------------