Ask Experts Questions for FREE Help !
Ask
    avrilfool's Avatar
    avrilfool Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Apr 15, 2007, 06:45 AM
    Making drop down and lookup dynamic
    I have a problem making lookup dynamic such that if items in drop downs change the lookup should also change. I have spent over a week and no clue comes up. A friend suggested this site for me and I'm confident to have answers after reading some of answers provided. Anyone to help? You can please leave your email so I can send the spreadsheet and a telephone number to call.I'm in Ghana and would be more than ready to call to discuss.

    Thanks
    Zak
    WvR's Avatar
    WvR Posts: 16, Reputation: 3
    New Member
    		  
    #2

    May 18, 2007, 01:22 AM
    I suggest having groups of drop down lists relating to groups of lookup tables seperatly in the workbook.
    Then create a set point for the drop down list and lookup table that will be used. These lists will be dynamic in so far as it refence the right group of drop down and lookup table.

    Say you have Group A and B

    When you want to use group A the user enters A in a specified cell, the set point drop down has the formula =if($B$1="A",+F2,+K2) where B1 is the cell where the user enters the list number he wants to use (A or B) do the same for the columns in the lookup field

    Now your dropdown data validation will always reference the same list address and so also the lookup table - but these two references will change depending on the user input of A or B
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

The request lookup key was not found in any active activation context [ 21 Answers ]

Hi there Please can somebody help me by guiding me on how to solve this problem I have with my internet. Well the problem is when I type in a web address in the address bar on top but every time I click on Go it comes up with : "THE REQUEST LOOKUP KEY WAS NOT FOUND IN ANY ACTIVAITON CONTEXT"...

Dynamic IP [ 1 Answers ]

Hi all the Experts,

Lookup key was not found [ 3 Answers ]

When trying to do a web search, or just typing a website address in the bar and hitting "GO"... I keep getting "THE REQUESTED LOOKUP KEY WAS NOT FOUND IN ANY ACTIVATION CONTEXT" Is this due to a software problem? OS problem? How do I make the insanity stop... :confused:

Forward lookup,reverse lookup [ 1 Answers ]

Hi I am not getting the idea what exactly is FORWARD LOOKUP, REVERSE LOOKUP,zones while configuring DNS . Can anone explain briefly or give me the link to go through:)

Cascading lookup fields... [ 3 Answers ]

Want to use the form frmCardDetails to populate tblCards. Want to select the sport from a lookup field linked to tblSports and then the League from tblLeagues, BUT only displaying the leagues that are included in that sport. I have looked at http://support.microsoft.com/kb/209595/en-us and...

View more questions Search