How to make a dropdown list in excel that inserts values ​​into 2 cells?

Question

excel

You need to make a drop-down list in a cell (4 values) on the first sheet in excel, when you select one of the items in the drop-down list in adjacent cells (preferably in a column, under the cell with the list), values ​​from the table on the second sheet should be inserted.

Answer 1

vpr