One often hears the question: "How to create a drop-down list immediately for an entire row, and not for a single column in a row?". Usually this is necessary to fill several columns at once with data when choosing a value from the list. Unfortunately, the drop-down list itself does not provide such an option. But the problem is easily solved by formulas.
This option is implemented by the VLOOKUP function or a combination of INDEX + SEARCH. We select one value that serves as a key (unique in the directory) from the list, and simply pull all other data into the table from the directory for the selected key.
Read more about dropdowns in article
#solo_scripts