Thread: Change cell based on answer in another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Change cell based on answer in another cell
Try this:
=CHOOSE(MATCH("x",A14:A20),"George", "Mary","Alice",
"Jane","Albert","Berak","Hillary")
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Ryan" wrote in message
...
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.


Reply With QuoteReply With Quote