"anon" wrote:

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

Thanks but its little complex than that. I just want ----- If a3=apple than
a4 should be from japan. Rest i dont care. But if i input formula in cell A3
it has to apply to all the cells in A4. I dont want that. I just want one to
data in A3 to relate to one data in A4.

Thanks.
RR