Data validation for multiple rows

Hi Everyone -

I know I can copy a basic data validation to multiple rows with no issue. However, I am using a helper column to search for the first few letters of a name and have data validation only show any names in my list with those letters. Example: If I type in jo, it will show me all names with jo, like john, joe, joseph, elton john, etc...

The drop down to choose is in cell, E2. How can I increment automatically to the next x number of rows? (E3, E4, etc...)

=SORT(FILTER($C$2:$C$8,ISNUMBER(SEARCH(E2,$C$2:$C$8)),"Not Found"))

This formula is in cell A2.

Thanks
Sluggy

Hi Diana -

I am actually referencing the indirect from another tab, 'Enter Reels'. I modified what you sent, and getting #CALC!
What do you think I am doing wrong? Feel I am very close !

=FILTER(Table1[Driver Name],ISNUMBER(SEARCH(INDIRECT("'"&Enter Reels&"'!A"&COUNTA('Enter Reels'!A:A)),"Not Found")))

Thanks so much,
Sluggy

Good Morning Hans

Attachment uploaded. Thanks for your help!!

Sluggy

Diana -

That did it!! Thanks!
Sluggy