Set value in excel based on a drop down list

Question

I need to make a drop down list in excel in the following style:

Merchandise | Value

In the same spreadsheet I have a table with a list of goods and their respective values.

Below the merchandise field I would like a drop down list with all the goods registered in the other table and the value field to be applied automatically when selecting a merchandise.

Thank you

Answer 1

In the commodity cell create a data validation. Go to the Data tab>Data Validation, in the Allow field choose the List option, will open a new field called font, click the Up arrow and select its table.

In the value cell, do a Procv. = Procv(Commodity cell;Select your Table;Column number where the value is;0)