Formulae return values to their calling cells - they can't change other
cells. Assuming C1 and D1 have the two names and the X will go in C2 or
D2:

=IF(C2="X",C2,IF(D2="X",D2,"")

In article ,
Leland wrote:

I am trying to create a elimination ladder and want to ceate a formula to
move names from one cell to another when an X is placed in a certain cell.
Example when cell C2 is checked as X name in C1 moves to F1