Dynamic dropdown menu based on two criteria

hi jrockdown,
so close! but thats only because i may need to execute more than 1 search at one time, within a table.
your formula works but one to create one dynamic list at a time. if i wanted to create more searches in the rows underneath, while maintaing the original entry, it wouldn't work as i would need to create a new list to create a second drop list from.

scottylad2,
i've attached a file which has two tabs:
1. table
2. source data

so, the criteria 1 determines the drop list for criteria 2, which determines the drop list for criteria 3. once criteria 3 has been selected, i'd like to begin a new search below it, and so on.

hope this helps. and thanks again

sorry guys, still need help on this one.
see above for the worksheet.
many thanks

Originally Posted by Darsk

hi jrockdown,
so close! but thats only because i may need to execute more than 1 search at one time, within a table.
your formula works but one to create one dynamic list at a time. if i wanted to create more searches in the rows underneath, while maintaing the original entry, it wouldn't work as i would need to create a new list to create a second drop list from.

scottylad2,
i've attached a file which has two tabs:
1. table
2. source data

so, the criteria 1 determines the drop list for criteria 2, which determines the drop list for criteria 3. once criteria 3 has been selected, i'd like to begin a new search below it, and so on.

hope this helps. and thanks again