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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill one cell based on the answer in another cell. 1
Lookup text in array & return cell reference 5
omiting cells in average calcs 3
Counting the number of cells between 2 seperate cells 2
Multiple IF statement not working 5
Change different cell based on conditional statement 4
repeating cells 2
SUMPRODUCT not working? 1

Top