3 droplist to have different fomulas acording to choice

[JaykSA]

i have 3 cells (all droplist)
Outerborder

• wood=$30
• polystirene=$50
• clay=$60

(WIth out showing the numbers)
CONTENT

• Filling=30%
• Fake=0
• wood=10%

SIZE

• 500mmx250mm=(*5)
• 450mmx250mm=(*4)
• 330mmx250mm=(*3)

all of them should work together to evaluate a price
in a nother cell
Any ideas???

 

[jbeaucaire]

Like so:

Excel 2010
	B	C	D	E	F	G	H	I
1	OuterBorder	Content	Size	Price
2	wood	Filling	500mmx250mm	$ 195.00			wood	$30
3	polystirene	wood	450mmx250mm	$ 6,200.00			polystirene	$50
4				n/a			clay	$60
5				n/a			Filling	30%
6				n/a			Fake	0
7				n/a			wood	10%
8				n/a			500mmx250mm	5
9				n/a			450mmx250mm	4
10				n/a			330mmx250mm	3
11				n/a
12				n/a
13				n/a
Sheet2

Cell Formulas
Range	Formula
E2	=IFERROR(VLOOKUP(B2, $H$2:$I$10, 2, 0)*(1+VLOOKUP(C2, $H$2:$I$10, 2, 0)) * VLOOKUP(D2, $H$2:$I$10, 2, 0), "n/a")

 

[JaykSA]

Sorry only saw this now. Thank you so much!!! Yo helped me loads

 

[jbeaucaire]

Glad it works for you.

 

[JaykSA]

Hi Jerry! sorry i am clueless to what I am doing wrong.

You formula works mine does nothing.

=IFERROR(VLOOKUP(C34,$X$35:$Y$82,34,0)*(1+VLOOKUP(E34,$X$35:$Y$82,34,0))*VLOOKUP(G34,$X$35:$Y$82,34,0),"N/a")

Set them all up as a droplist

I am not to clued up. For someone that now how this works could you tell me where i went wrong?
Sorry for all the questions

 

[jbeaucaire]

There are only 2 columns in the search range, X:Y. The third parameter of a VLOOKUP is the column number in the designated range, since your range only has 2 columns, the highest number would be 2 for the third parameter, but you put 34 for some reason. Try 2 instead, 2 would bring back the answer from the 2nd column in the designated search range.

 

[JaykSA]

ahh okay now I get it