Quote:
Originally Posted by escelnewbie
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.
|
I'm not sure what it is you're actually trying to do here. Which cell are you putting that formula in?
Perhaps you could post an example workbook to make things clearer?