Change cell based on answer in another cell

R

Ryan

I am trying to make a cell have an "x" marked in it if another cell has a
certain word in it. Example: F2=George then A14=X, If F2=Mary then A15=X.
 
B

Bernard Liengme

Try this:
=CHOOSE(MATCH("x",A14:A20),"George", "Mary","Alice",
"Jane","Albert","Berak","Hillary")
best wishes
 
Top