Data Validation List based on Matched Cell Reference

I am seeking help with an Match Based Array that is compatible for Data Validation List / Cell Drop Down.

Basically what I need is a Drop down list with options based on a Cell Reference Match with previous record database. If no match found (new input) default list will be shown.

Sheet 1: Input Sheet 2: Database

I used name manager and created name

strname = list of store in database {Database Sheet Cell Columnn B5:B10}

gen_addrs = for default list {Database Sheet Cell Columnn C5:C10}

m_addrs = if match list with with formula =

=INDEX(gen_addrs,MATCH(Input!$C6,strname,0),1):INDEX(gen_addrs,MATCH(Input!$C6,strname,1),1)

*relative Row Absolute Column starting with C6

In Data Validation List I tried the following formula but does not wok

=IFERROR(m_addrs,gen_addrs) 

also tried but does not work

=IF(MATCH(Input!C6,strname,0),m_addrs,gen_addrs)

Looking for a viable solution.

See attached pics for more reference

Thank You!

With this formula

=LET(a,MATCH(Input!C6,strname,0),IF(ISNA(a),gen_addrs,INDEX(gen_addrs,a):INDEX(gen_addrs,COUNTIF(strname,Input!C6)+a-1)))

(the slightly shorter

=LET(r,MATCH(Input!C6,strname,0),IF(ISNA(r),gen_addrs,TAKE(DROP(gen_addrs,r-1),COUNTIF(strname,Input!C6))))

could be used instead)

used in your data-validation rule:

the data-validation can be seen to work: