My situation is this: If the cell is empty then pick a name from a drop down list from another cell, but if it is not blank then leave current data alone. The first part is easy enough IF(A1="", C1, ?) but the second part I cannot figure out with the cell referencing itself and giving error.
Can anyone help.