Ask Your Question

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

asked 2014-01-25 22:28:22 +0200

Ynatar gravatar image

updated 2014-01-25 23:53:39 +0200

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€

image description

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 03:34:13.292219

1 Answer

Sort by » oldest newest most voted

answered 2014-01-25 23:27:43 +0200

m.a.riosv gravatar image

updated 2014-01-26 02:11:31 +0200

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.

image description
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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-01-25 22:28:22 +0200

Seen: 1,001 times

Last updated: Jan 26 '14