# 3 droplist to have different fomulas acording to choice

#### JaykSA

##### New Member
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???

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Like so:

#### JaykSA

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

#### jbeaucaire

##### Well-known Member
Glad it works for you.

#### JaykSA

##### New Member

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

##### Well-known Member
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

##### New Member
ahh okay now I get it

Replies
1
Views
162
Replies
2
Views
228
Replies
10
Views
112
Replies
1
Views
229
Replies
0
Views
47