View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tomj37 Tomj37 is offline
external usenet poster
 
Posts: 1
Default How do I give numerical values to each text item in a list

Hello, how do I set up a validation list, or any sort of dropdown list which
has text to chose from e.g a products list.

and when selected each product has a numerical value (price)

And then create a total from quantity x price(what was selected in the drop
down's numerical value)