Dependent Data Validation - Set First Item as Default

Hi,

Is there any way when using dependent validation lists, that once a selection is made in one list, the next list will automatically default to it's first item?

So in the attached example, if Activity2 is selected in cell B7, then TaskC would automatically appear in cell C7 but the user can still choose a different value if necessary?

Thanks.

The formula below should work.

Formula:

Please Login or Register  to view this content.

Hi,

Thanks for your reply. That formula works but it only returns one match, or did you mean me to put it into the Data Validation source some way?

I still need the user to be able to select from all the options for each activity as listed NewList sheet.

So basically, I need to keep the data validation list in cell C7, but have it default to the first item in the list, while still allowing the user to choose something else...

Just bumping this up to see if anyone else has any ideas?

Thanks.