Is it possible that a drop-down could fill subsequent cells of the rows?

[Ynatar]

I would like to know if it’s possible that when you choose from a drop-down list, other cells can be filled also. I’m trying to simplify cake cost calculation. I have a sheet with Product Description, Quantity and Price. In the other sheet I want to calculate for each cake.

What I would like to happen is as shown in image below: For example when I choose from the drop down list “Farinha”, it autofills in the other sheet under “Valor” 0,00083€

[mariosv]

With the value in the drop-down cell, you can get the values calculated in other cells, a usual function is:
=VLOOKUP(SearchCriterion; Array; Index; SortOrder)

Sample with the formulas to the right of the values.

.
.
You can use VLOOKUP() as showed in the screenshot adapted to your case.

In C3: =VLOOKUP($A3;SheetX.$G$1:$H$14;2;0)

SheetX is the sheet name where the table is.