Change cell based on answer in another cell

  • Thread starter Thread starter Ryan
  • Start date Start date
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.
 
Try this:
=CHOOSE(MATCH("x",A14:A20),"George", "Mary","Alice",
"Jane","Albert","Berak","Hillary")
best wishes
 
Back
Top