Need macros in the Excel table

Andrey
Employer

[no-member:pro]Andrey[/no-member:pro]Andrey

1 projects
Closed
Project parameters
Type of cooperationOne-time project
Prepaymentwithout prepayment
Payment methodsBank transfer, Electronic money
Acceptance of requestsclosed
Project description
For example:
In the yach. A1 list of values (Data-Verification-List)
When choosing the value of_1 in a bar. B1 is substituted with List_1
When choosing the value of_2 in a bar. B1 is substituted List_2
When choosing the value of_N in the bar. B1 is substituted with List_N

All lists are named ranges.
Project author: Andrey