Hi All

Does anyone know how to make a drop down list using the Indirect formular, that will automatically select the first value in the indirect list?

So lets say I have two lists...

1st:
Monkey
Elephant
etc

My indirect list for monkey is:

Banana
Nuts
etc


When "Monkey" is select in the first list, I want the indirect list to automatically select(show) "Banana"

Thanks for any help you can give