Excel Advanced formula Assistance

[Rebecca_Schemm]

=IF(A2="Complete",B2,"")

however, if B2 is blank then want to return C2, and if C2 is Blank want to return D2

tried nesting =IF(AND formulas.. nothing is working

[#2 · Accepted solution]

@Rebecca_Schemm 

If it's just those cells:

=IF(A2="Complete", IF(B2="", IF(C2="", D2, C2), B2), "")

If you want to return the first non-blank cell to the right of A2 (B2 or C2 or D2 or E2 or ..., up to for example Z2):

=IF(A2="Complete", IFERROR(INDEX(B2:Z2, MATCH(TRUE, B2:Z2<>"", 0)), ""), "")

[#3]

THANK YOU!!!!!