Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF funtion question
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. |
#2
|
|||
|
|||
Quote:
Perhaps you could post an example workbook to make things clearer? |
#3
|
|||
|
|||
Quote:
ex. Jan1, 2013 A1-- Joe A2-- julie A3-- (available) A4-- (available) A5-- (available) drop down list will be from seperate sheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What funtion to use? | New Users to Excel | |||
IF funtion question | New Users to Excel | |||
If Funtion | Excel Worksheet Functions | |||
If funtion help | New Users to Excel | |||
IF funtion | Excel Discussion (Misc queries) |