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","")
|