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

Quote Originally Posted by Darsk View Post
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