Quote Originally Posted by davesexcel
have you considered a dropdown menu in A1

select A1
got data,validation
from the allow box select list
in the source box enter
boy,girl,baby

now you have a dropdown menu in A1

then you could just reference A1,
in cell D1 enter this =A1, now select an item from your dropdown menu



As for your question
is it possible that A1=boy and A2 =girl at the same time?
I actually want the condition to be printed on another column, sorry for the messy wordings...want it to look something like this...

Column A is "Department"
cell A1=1
cell A2=2
cell A3=3

I actually want row B1 to type "boy" if A1 reads "1" like
cell A1=1 cell B1 would show the word "boy"
cell A2=2 cell B2 would show the word "girl"
cell A3=3 cell B3 would show the word "baby"
cell A4=2 cell B4 would show the word "girl" again