Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have three columns. "Site ID" with a value, "Ready" with date and "Installation Completed" with date.

Now I want that I search whole column B for non-blank cell, if I found then it checks column C is blank, if column B is blank then write value of Column A in Column D where I am writing formula otherwise move to search for next non-blank value in Column B.

Hope you understand and help me with solution.

share|improve this question
    
What would the argument be for column C "Installation Complete"? So if B is blank, is there a need to check c? If there is, would you want a notice like "Ready Date Missing" to appear in column d? –  Carl B Aug 12 '12 at 5:32

1 Answer 1

Assuming "Site ID" is column A, "Ready" is B, and "Installation Complete" is C. You could use the following formula in column D and then copy it down as many rows as you need.

=IF(ISBLANK(B2),"",IF(ISBLANK(C2), A2,""))

This checks to see if cell B2 is blank and if so, does nothing else. If B2 has a value it will then check C2 for a value. If there is nothing in C2 it will show the value of A2.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.