Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > Dependent validation for a contact directory
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
  
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up
Quote:
Originally Posted by km1735 View Post
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.
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
Reply With QuoteReply With Quote
  #2   Report Post  
Junior Member
  
Posts: 3
Default
Quote:
Originally Posted by Mazzaropi View Post
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.
Attached Files
File Type: zip Help.zip (10.0 KB, 36 views)
Reply With QuoteReply With Quote
  #3   Report Post  
Senior Member
  
Location: Belo Horizonte, Brazil
Posts: 170
Exclamation
Quote:
Originally Posted by km1735 View Post
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.
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
Reply With QuoteReply With Quote
  #4   Report Post  
Senior Member
  
Location: Belo Horizonte, Brazil
Posts: 170
Default
Try this new one
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
Reply With QuoteReply With Quote
  #5   Report Post  
Junior Member
  
Posts: 3
Default
Quote:
Originally Posted by Mazzaropi View Post
Try this new one
This is exactly what I was looking for! Thanks a ton. Saved my life here. Cheers!
Reply With QuoteReply With Quote
  #6   Report Post  
Senior Member
  
Location: Belo Horizonte, Brazil
Posts: 170
Thumbs up
Quote:
Originally Posted by km1735 View Post
This is exactly what I was looking for! Thanks a ton. Saved my life here. Cheers!
HELP from BRAZIL <<<

Dear KM1735, Good Morning.

I feel glad that my help worked for you.
Have a nice day.
__________________
I hope it can help you.

Best regards,
Marcilio Lobão
---------------------------
Belo Horizonte, Brazil
Reply With QuoteReply With Quote
  #7   Report Post  
Junior Member
  
Posts: 3
Default
Quote:
Originally Posted by Mazzaropi View Post
HELP from BRAZIL <<<

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 the template for more rows. For example, if I use the same data validation in cells A3(Banks) and B3(Contacts) of the template, the list doesn't change (contacts for banks in cells A2 appear there too).

I was trying to fix it, but couldn't get it working. Thanks!
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Dependent Data Validation Shacks Excel Discussion (Misc queries) 3 August 12th 09 06:58 PM
Dependent Validation Paul Excel Worksheet Functions 1 February 13th 09 08:01 AM
Dependent Validation Paul Excel Worksheet Functions 1 February 12th 09 11:57 PM
Dependent Validation Paul Excel Worksheet Functions 1 February 12th 09 11:56 PM
Dependent DropLists - Using Validation ABlevins Excel Worksheet Functions 1 April 7th 08 03:57 PM


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement