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:


    Any help would be appreciated

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

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    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
    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