Results 1 to 3 of 3

Thread: Show list based on cell value

  1. #1

    Show list based on cell value



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all,

    I have a data sheet with two lists (Data Validation List A and List B within Excel 2007).

    What I am trying to do is:

    1. Provide a drop down on a second sheet which will show either List A or List B when selected;
    2. The criteria will be based on whether B5=0;
    3. If not then the second list will be provided.

    I have tried using the INDIRECT function which shows the first list but not the second. Here is the formula I used:

    =IF(B5="",ListA,INDIRECT("ListB"))

    Any help would be appreciated

    Thanks
    Last edited by Togora; 2016-01-16 at 10:44 PM. Reason: missing information

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Posts
    901
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by Togora View Post
    Any help would be appreciated
    Look maybe you can help my example.
    There are two dependent drop-down list. The formula for the second drop-down list is
    Code:
    =INDIRECT(B14&"_company")
    Attached Files Attached Files

  3. #3
    Hi Navic,

    Many, many thanks for your efforts but I feel you have wasted your time perhaps because I wasn't clear enough about what I was after, so my sincere apologies for that.

    I woke up this morning and within minutes wrote the formula I was looking for. This is it - "=IF(B5="",ListA,ListB)" - yes it was that easy!

    So again my apologies for wasting your time and thanks for your suggestion.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •