Swap Cells based on Cell value

[RedOctoberKnight]

Good Morning,

I was wondering if anyone had any ideas on how to swap the contents of two cells based on 3rd cells value?

For example Currently: A1=CAT, B1=DOG. If C1 ="SWITCH", THEN A1=DOG AND B1=CAT.

If C1 Changes again to something other than "switch" , then A1=CAT and B1=DOG again....

Any help would be much appreciated.

Thanks,

 

[Joe4]

Thats is a very good point. May have to rethink my tactic.

Hopefully I'm not being too needy but my I ask another question?
What if i wanted to switch the contents of two cells that are in the same column? But have it switch with a specified cell based on a cell value.

For example,

A	B	C	D
Jim	Cat	Bob	SWITCH
Dan	Dog
Bob	Bird
Greg	Cat

So basically, if I put Bob in column "C" and put "SWITCH" in column "D", it would switch the contents of column B between Jim and Bob

A	B	C	D
Jim	Bird	Bob	SWITCH
Dan	Dog
Bob	Cat
Greg	Cat

Hopefully that makes sense.

Thank you for all your help so far.

Sure, you can ask more questions.
But it is probably best to ask it in a new thread, as it is a new/different question.