View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Powder Coating Mike Powder Coating Mike is offline
external usenet poster
 
Posts: 1
Default referencing drop down menu values in IF-then statements?

I'm trying to use a drop down list to automatically input numbers into two
other cells.

eg

Drop-down menu Price 1 Price 2

what I'd like do is have it so that once I choose an item from the drop down
menu the cells of Price 1 and Price 2 woudl be automatically filled with the
proper number.

any suggestions???

Mike