Iam wondering how I can get a list of drop down words to have value to that everytime they are picked a tally adds the valuses associated together?
For example if I create a drop down menu with hamburger how to I get the word hamburger to = $7.00 when selected?
Maybe a event macro. Right click sheet tab to view code.
or if you need to use in a formula then try name ranges
http://www.bettersolutions.com/excel...L325782331.htm
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Create a lookup table with items and associated prices...then use Vlookup.
e.g. =Vlookup(A1,X1:Y100,2,0) would look up the item in A1 in the Table located in X1:Y100 and return the corresponding price found in column Y.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
not so good with macros so ill try the table.can i create the table in another workbook and then have it apply when the cell is chosen in my main workbook?
Yes, you can, as long as you reference the entire path of the workbook...Originally Posted by Kelly333
e.g.
=VLOOKUP(A1,'C:\Documents and Settings\[Book4 Nov6.xls]Sheet1'!$X$1:$Y$100,2,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Kelly333 
Register To Reply
Bookmarks