View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rayapura@gmail.com is offline
external usenet poster
 
Posts: 1
Default Assigning numeric value to text in drop-down menu

I am trying to create a drop-down list of materials and would like to
assign different numeric values to each material,which will be used in
calculations i.e. Under drop-down list of Materials, Wood=1, Steel=2,
etc.
Please help!!

-Aarthi