Show list based on cell value

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

Togora said:

Any help would be appreciated

Click to expand...

Look maybe you can help my example.
There are two dependent drop-down list. The formula for the second drop-down list is

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.