Getting multiple Dropdown menus to give an answer in a specified cell.

[Mcullin]

Hello and good day everyone,
I am able to get the formula correct in the destination cell for my first drop down menu. My problem arises when I try to use the same cell for the next dropdown menu. I have attached my basic sheet if you should have any questions but will post the formula also.

" =IF(OR(D3="azul platino",D3="black/white", D3="giallo fantasia"),B8*28,IF(OR(D3="Bainbrook Brown",D3="Crema Caramel"),B8*28,IF(OR(D3="Rosa Fresca",D3="ubatuba"),B8*28,"not, , azul platino, black/white, bainbrook brown, crema caramel,giallo fantasia, rosa fresca, or ubatuba")))*1.22 "

I am sure I took the scenic route to get my results also, sorry if it seems elementary, that is about my grade level on excel. My intention is to have my groups of granite in each drop down menu. As you choose the group and corresponding color it will calculate the wholesale and retail prices. BUT each group must have a higher cost. The 1st group $28 the 2nd group $38 , 3rd group $48, & 4th group $58.

Thank You in advance for any help.
Michael

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[Mcullin]

My solution was to trash the concept and just do it all in one drop down list with GROUPS all on one line showing 20 at the time. The formula is long because I used the names of each piece.