LinkBack URL
About LinkBacks
I am new to advanced excel,I have constructed a dropdown menu of some groups now I want
whoever selects a particular name to see another cell get populated with preset values and
also be able to calculate with those values. thank you
I am new to advanced excel,I have constructed a dropdown menu of some groups now I want
whoever selects a particular name to see another cell get populated with preset values and
also be able to calculate with those values. thank you
try....
=vlookup(drop-down-cell-reference,range-where-your-data-is,column-you-want-to-look-in,fallse) the ,false is so you can look in an unsrted range
if this doesnt work for you, perhaps consider uploading a sample workbook?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
These are called Dependent Drop Down lists and they use named ranges and INDIRECT() references for Data Validation lists in the proceeding drop boxes.
Here's a sample sheet I've posted showing how it's done. The sheet "CHOICES" has the dependent drop lists (and shows one of the dangers of using them) and the sheet "LISTS" shows the lists and named ranges in use.
Have a look.
Sample FilesThe files you want to examine are:
--DependentLists3.xls - 3 levels
--DependentLists2.xls - 2 levels
--DiminishingDropDownList-NonArray.xls
--DependentLists-SelfSorting.xls - Self-Sorting lists of fruits by color choices
More reading:
http://www.contextures.com/xlDataval02.html
http://www.contextures.com/xlDataVal13.html
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for the replies, what I really mean is this,let's say there's a cell B2 and it contains a dropdown list of banks, so that when a bank for instance BankA is selected in the dropdown list populates cell D4 with bankA's lending rate. The lending rate displayed and maybe the bank's ceo's name in another cell D6.and if bankB is selected from the list same thing happens except that it's bankB's lending rate and ceo that is displayed in cell D4 and D6.regards
That's a VLOOKUP formula.
Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks