View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
anon anon is offline
external usenet poster
 
Posts: 77
Default How to automate?

I may have understood this wrongly, but if it's that simple,

In A3 set data validation to list, and to a set of cells containg the
values, Apple, Orange etc
In a4 set a formula =if(a3="Apple","From Japan",if(a3="Orange","From
Spain","")