Drop Down Menu Values

OK, I believe this is the right part of the forum to ask this!

So, I have setup a worksheet with multiple drop down menu's, all with different available options to choose from. If I go to the 1st drop menu and select say option 2, is there a way I can assign a dollar value to option 2 so that when I select that option, it posts the dollar value next to the drop menu? Then go to the 2nd drop menu select say option 4 or whatever, and do the same with the value.

That way at the end of the list of drop menu's I have a total of what the options that I have chosen for this particular piece to have and have a running total of what it costs?

To get the drop menu's I just listed a bunch of options for question 1, then went to data, validation, list, and selected those options. Then did the same and so on for other options.

Thank You,
-Matt

Create a table on the side with all the "options" listed in one column and the corresponding values in the adjacent column... then use Vlookup() to extract the right one.

e.g. if your drop down is in A1 and your table is in X1:Y100...

=Vlookup(A1,$X$1:$Y$100,2,FALSE) would extract the corresponding value from column Y where column X matches the option selected in A1.

Good afternoon slvr98svt

Originally Posted by slvr98svt

If I go to the 1st drop menu and select say option 2, is there a way I can assign a dollar value to option 2 so that when I select that option, it posts the dollar value next to the drop menu?

You can do this, but you haven't given much information specific to your case, so here's a generic answer.

You will need to set up a table that lists all your options, and then in a cell to the right lists the respective values of those options. Once you have your table, in the cell next to your fist dropdown you will need to use a VLOOKUP formula that might look something like this :
=VLOOKUP(A1,D1:E10,2,0)
where A1 will be your dropdown cell, D1:E10 is the address of your table and the 2 represents how many columns need to be counted across to the right once the value in A1 is found in the column D1:D10 (which is what VLOOKUP does).

Reading back it sounds quite complicated but it's not - if you need any more help post back.

HTH

DominicB

Im sorry but that totally has me confused! I have included a quick example of what I am trying to do. I setup my list in rows and then with prices underneath, is it still possible to accomplish this? I would like to be able to select say the 68 and then in column C have it put the price next to the menu?

Basically I am unsure where to put the vlookup as far as what cell?

\1

Since you set up your lookup table horizontally, you will need HLOOKUP instead of VLOOKUP.

In C5 enter formula: =Hlookup(B5,$G$5:$I$6,2,FALSE)

Have a look at Excel Help on these 2 very useful functions to understand more how they work.

Please mark your thread as Solved and then post your new question in a new thread.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Please mark your thread as Solved and then post your new question in a new thread.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save