If cell A = X then put text ..., if not see cell B and arrange try the same

[dutchmaste]

Hopefully somebody can help me. I have been searching all of the net, but couldn't find it.

I have multiple cells where some one can write a X.

Now I want a certain cell to show at which cell the other person put the X

For example in cell A2 it needs to show what has been filled in at either cell A2, A3, A4. Now if A2 has X I want it to showin cell A1 "CAT", if A3 has X then I want it to show "DOG" in cell A1, etc. etc.

[NBVC]

Does only one of those three cells have an X at any time, or could more than 1 have an X? And if so, which X is processed?

[dutchmaste]

In this case only 1 X should be filled in. But if you could help me with multiple as well that would be great as I know I will get there further down the road.

So incase of multi it should have a outcome like CAT, DOG

[NBVC]

So we are only dealing with at most 3 cells occupied with an "X"?

[dutchmaste]

For now it is just one X, but if you could provide me with both that would be really great.

[NBVC]

Well this will work with either case of one, two or three "X"'s


=SUBSTITUTE(TRIM(IF(A2="x","cat","")&" "&IF(A3="x","dog","")&" "&IF(A4="x","mouse",""))," ",",")

An alternative, if, for sure only one "x" is entered (or you want the first "x" only)....

=CHOOSE(MATCH("x",A2:A4,0),"cat","dog","mouse")

[dutchmaste]

Awesome, thnx so much